Sqlite and performances in LiveCode

[Pete]

Hi Trevor,
Thanks for making that change.

I've been following up a bit more on the behavior of GetDataForLine being
called in repeated cycles for the number of lines in the datagrid.  As a
reminder, the datagrid has 11 visible lines, GetDataForLine gets called
once for lines 1-12, then a second time for lines 1-2 again, and
occasionally a third time for lines 1-2.

I think I know the reason this is happening.

The first GetDataForLine cycle happens when I set the dgProps["Columns"]
property of the datagrid.

The second cycle happens when I set the dgNumberOfRecords property.

There's a possible third cycle because sometimes I set the dgProps["Sort By
Column"] property.

I have tried setting the dgNumberOfRecords to empty, zero, or NULL before
any of the above properties are changed but it doesn't seem to make any
difference.

Hoping you may have a recommendation as to how to avoid these multiple
cycles!

Thanks,
Pete



On Mon, Mar 12, 2012 at 7:01 AM, Trevor DeVore <lists at mangomultimedia.com>wrote:

> On Thu, Mar 8, 2012 at 2:47 PM, Jérôme Rosat <jrosat at mac.com> wrote:
>
> > Trevor, yes I'm going to try.
> >
> > But I think it would be a good idea if you could change your stack in the
> > lesson "Displaying Large Amounts of Data" to demonstrate the performance
> of
> > LiveCode.
> >
>
> I've updated the stack to use the new technique. You can download it from
> the same url. I'm on a faster machine testing but here are the times I get:
>
> Opening movies cursor took 150 milliseconds
>
> -------
>
> Drawing list took 81 milliseconds
>
> -------
>
>
> --
> 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>