Sqlite and performances in LiveCode

Pete pete at mollysrevenge.com
Tue Mar 6 12:15:17 EST 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.
Pete

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



-- 
Pete
Molly's Revenge <http://www.mollysrevenge.com>



More information about the use-livecode mailing list