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 = "D:/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