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 <li...@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> _______________________________________________ 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
