Bob, how do you control whether SQLite pages the table in from disk or maintains it entirely in memory?
-= Mike On Sep 29, 2014, at 12:14 PM, Bob Sneidar <bobsnei...@iotecdigital.com> wrote: > Might just be simpler to put the data into a memory based sqLite table, then > delete the column and put the data back into a string list. But of course > that begs the question, why are you not using arrays and sql tables in the > first place? I’ve pointed out before that the array retuned in Trevor > DeVore’s sqlYoga is a numerically indexed array that a data grid’s data can > be directly set to. They are identical in structure, making it very simple to > display table data in a data grid. > > That being said, extra data in a data set doesn’t really hurt anything. I get > all the columns in my SQL queries, and then set my data grid to only have the > columns I want displayed. Now I have a ready made local instance of all my > data which I can access without additional queries. It’s not efficient I > admit, especially with a lot of data, or data containing large amounts of > binary data in blobs, but if I were doing that I would adapt accordingly. > > Bob S > > > _______________________________________________ > use-livecode mailing list > use-livecode@lists.runrev.com > Please visit this url to subscribe, unsubscribe and manage your subscription > preferences: > http://lists.runrev.com/mailman/listinfo/use-livecode _______________________________________________ use-livecode mailing list use-livecode@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-livecode
