Sqlite and performances in LiveCode

[Pete]

Hi Bernard,
Sorry to hear about Eric and ListMagic.

I'm certainly not knocking the datagrid, it was a great addition to the
Livecode arsenal of controls, no doubt about that.

I have used both dgText and dgData and have not noticed a significant
difference in performance which, as you say, is contrary to some of the
posts on that subject.  Maybe it depends on other variables such as how
much column customization has been done.

Pete

On Mon, Mar 5, 2012 at 10:54 AM, Bernard Devlin <bdrunrev at gmail.com> wrote:

> There was such a datagrid-lite control a few years back, produced by
> Eric Chatonet.  Sadly Eric died, and ListMagic appears to no longer be
> maintained.  It used the basic field object, and well, it did some
> quite magical things with it.  I think ListMagic stopped working with
> some changes introduced in the LC 4.x series (at least, it stopped
> working for me).
>
> However, I have been truly astonished with what Trevor's Data Grid can
> achieve (and IMO it is far more than a data grid, it is almost a
> framework).
>
> Have you tried setting the dgText rather than the dgData?  In my
> experience the former is much faster than the latter, which goes
> against some of the things I've heard people say here, namely that the
> Data Grid control will convert an such dgText into dgData before
> displaying it.  The relative speediness of setting dgText makes me
> think that cannot be true (although I haven't bothered to dig into the
> code to see what is going on).
>
> When working with the dgText and Sql Yoga, I've found that retrieving
> results from a database as "data" (i.e. a list) rather than array, in
> order to feed that list to the dgText is by far the quickest way to
> go.  Even with dgText one can still do formatting/transformations on
> columns.
>
> Bernard.
>
> On Mon, Mar 5, 2012 at 6:25 PM, Pete <pete at mollysrevenge.com> wrote:
> > I agree with you - datagrids are powerful, complex structures and come
> with
> > a cost.  They're a great tool for sure and I use them a lot when I need
> > their functionality, especially if I need to include option menus,
> > checkboxes, or any other column customizations.  But I'm increasingly
> > starting to use scrolling lists and table fields when all I need is to
> > present a simple list of data for the user to select from and display
> more
> > information or carry out some action on the selected line.
> >
> > It feels like there's room for another type type of control that goes a
> bit
> > further than basic tables but not as complex as datagrids, kind of a
> > datagrid-lite.
>
> _______________________________________________
> 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>