Hi Mke, Don't recall if this is an SQLite database in question but if so, there are various PRAGMA statements that control caching, page size etc. Check out www.sqlite.org for more info.
Pete lcSQL Software <http://www.lcsql.com> Home of lcStackBrowser <http://www.lcsql.com/lcstackbrowser.html> and SQLiteAdmin <http://www.lcsql.com/sqliteadmin.html> On Tue, Sep 30, 2014 at 11:12 AM, Michael Doub <miked...@gmail.com> wrote: > I think that puts the whole database (multiple tables) in memory. Bob > mentioned only the table so I thought he might know of some other magic > incantation. :-) > > -= Mike > > > On Sep 30, 2014, at 12:05 PM, Dr. Hawkins <doch...@gmail.com> wrote: > > > On Mon, Sep 29, 2014 at 3:58 PM, Michael Doub <miked...@gmail.com> > wrote: > > > >> Bob, how do you control whether SQLite pages the table in from disk or > >> maintains it entirely in memory? > >> > > > > use :memory: as the file name. Blindingly fast. > > > > > > > > -- > > Dr. Richard E. Hawkins, Esq. > > (702) 508-8462 > > _______________________________________________ > > 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 > _______________________________________________ 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
