08-27-2019, 09:22 PM
Hi. I'm full of questions and have appreciated several helpful answers so far.
To speed processing I'm trying to reduce the number of queries to the cloud my app needs to make. So I'd like to query, retain the data locally temporarily and make further queries to local. Then at end of session update any records that have changed to the cloud. I've wondered about three approaches I hope could work.
1) I make this query.
cdb_batchQuery(tInputA,"cloud","logicalAND","recordData") into tOutputA
Can tOutputA be queried and updated as if it were a table? If so, what's the syntax?
2) If what I've suggested above isn't possible, what is the syntax to populate the data in tOutputA to a local table?
Is put cdb_batchCreate(tInputA, "local") into tOutputB sufficient or are steps required before that command to create a new table?
3) I am aware of the cdb_loadTable command, but I would greatly prefer not to load the entire table, but instead a subset of the table's contents defined by a query. Is that doable?
I imagine there are good solutions available. What are they? Thanks in advance!
To speed processing I'm trying to reduce the number of queries to the cloud my app needs to make. So I'd like to query, retain the data locally temporarily and make further queries to local. Then at end of session update any records that have changed to the cloud. I've wondered about three approaches I hope could work.
1) I make this query.
cdb_batchQuery(tInputA,"cloud","logicalAND","recordData") into tOutputA
Can tOutputA be queried and updated as if it were a table? If so, what's the syntax?
2) If what I've suggested above isn't possible, what is the syntax to populate the data in tOutputA to a local table?
Is put cdb_batchCreate(tInputA, "local") into tOutputB sufficient or are steps required before that command to create a new table?
3) I am aware of the cdb_loadTable command, but I would greatly prefer not to load the entire table, but instead a subset of the table's contents defined by a query. Is that doable?
I imagine there are good solutions available. What are they? Thanks in advance!