Sqlite and performances in LiveCode

[Pete]

Hi Trevor,
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?

Pete

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:
> http://lists.runrev.com/mailman/listinfo/use-livecode
>
>


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