Sqlite and performances in LiveCode
lists at mangomultimedia.com
Tue Mar 6 07:01:58 CST 2012
On Tue, Mar 6, 2012 at 6:02 AM, Bernard Devlin <bdrunrev at gmail.com> wrote:
> The difference might be explained due to Livecode setting a smaller
> cache size than other applications.
> 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.
Blue Mango Learning Systems
www.clarify-it.com - www.screensteps.com
More information about the use-livecode