cacheDSNow
Syntax
cacheDSNow(ds)
Arguments
ds is a data source or a list of data sources.
Details
Immediately execute and cache the data source. It returns the total number of cached rows.
Examples
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