Sqlite and performances in LiveCode
pete at mollysrevenge.com
Thu Mar 8 00:16:48 CST 2012
I tried this approach in Livecode an it works great.
I do have one strange thing going on which I hope you can help with. There
are 12 lines in my datagird. I put a breakpoint in GetDataForLine and I
see it being called 12 times followed by a slight pause, then it's called
another 12 times. I've double checked my code and I'm certain I'm only
setting dgNumber ofRecords once. Any ideas?
On Wed, Mar 7, 2012 at 8:19 PM, Trevor DeVore <lists at mangomultimedia.com>wrote:
> On Wed, Mar 7, 2012 at 11:37 AM, Pete <pete at mollysrevenge.com> wrote:
> > I emailed sqlitemanager support re the manage/sql tab performance
> > difference. Mystery solved by the reply:
> > "In the Manage panel when you see SELECT * FROM table the real query
> > executed is SELECT rowid FROM table and then a SELECT * FROM table WHERE
> > rowid=N is execute for each visible row of the listbox. In the SQL panel
> > query executed is just what you type"
> Thanks for following up on that Pete.
> Jérôme - you might try something like this in LiveCode. If you set up the
> data grid like the example stack then you would call "SELECT rowid FROM
> table" to get the number of records and a list of ids. Then in
> GetDataForLine you would execute "SELECT * FROM table WHERE
> rowid=N" to fill in the row data that is being displayed.
> Trevor DeVore
> Blue Mango Learning Systems
> www.clarify-it.com - www.screensteps.com
> use-livecode mailing list
> use-livecode at lists.runrev.com
> Please visit this url to subscribe, unsubscribe and manage your
> subscription preferences:
Molly's Revenge <http://www.mollysrevenge.com>
More information about the use-livecode