cacheDSNow

cacheDSNow(ds)

ds is a data source or a list of data sources.

Immediately execute and cache the data source. It returns the total number of cached rows.

PTNDB_DIR = "/home/db_testing"
dbName = database(PTNDB_DIR + "/NYSETAQByName")
Trades = dbName.loadTable(`Trades)

ds=sqlDS(<select Time,Exchange,Symbol,Trade_Volume as Vol, Trade_Price as Price from Trades>)
ds.cacheDSNow()        //cache the data immediately
ds.clearDSCacheNow()   //clear the cache immediately