Sqlite and performances in LiveCode

[Trevor DeVore]

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.
>
> 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