On Tue, Mar 6, 2012 at 6:02 AM, Bernard Devlin <bdrun...@gmail.com> wrote:
> The difference might be explained due to Livecode setting a smaller > cache size than other applications. > > http://web.utk.edu/~jplyon/sqlite/SQLite_optimization_FAQ.html > http://www.sqlite.org/pragma.html#pragma_cache_size > > I don't know if the cache size is under one's control with sqlite. I just tried changing the cache size using the PRAGMA statement. While SQLite reports the new value I set the query speed does not change. The SQLite docs say that the value can be changed on the fly so that the value can be optimized for specific queries. -- Trevor DeVore Blue Mango Learning Systems www.clarify-it.com - www.screensteps.com _______________________________________________ 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
