Sqlite and performances in LiveCode
pete at mollysrevenge.com
Tue Mar 6 11:15:17 CST 2012
I got the same results on the movies database and even more pronounced
differences on a table in one of my own databases with ~48k records in it:
SQL tab 0.519secs, Manage tab 0.045 secs, more than a 10-fold difference!
Just a straight SELECT * in each case.
On Tue, Mar 6, 2012 at 4:56 AM, Trevor DeVore <lists at mangomultimedia.com>wrote:
> just tried SQLiteManager 3 on my primary computer and I'm seeing similar
> results. The Manage tab (which provides a UI for generating queries)
> reports that the same query is twice as fast as the SQL tab (where you
> enter your own query string). I'm intrigued as to why this is.
Molly's Revenge <http://www.mollysrevenge.com>
More information about the use-livecode