Custom Property Data Limit?

Pete pete at mollysrevenge.com
Thu Dec 1 19:55:55 EST 2011


Yeah, I can see that would work faster than getting the data from an SQL
db.  Would be interested to compare speeds with more complicated retrievals
though, eg get a list all rows with "xyz" in column 5 and "abc" in column
8, or something similar.  Course, the app in question may not need that
kind of complexity.
Pete
PS This reminded me of the difference between an American billion and and
English billion....

On Thu, Dec 1, 2011 at 4:42 PM, <dunbarx at aol.com> wrote:

> Just for the hell of it, I made a custom property of a button with one
> billion chars, 100,000,000 lines of ten chars. If I ask it for line, say,
> 28455999, it gives it instantly.
>
>
> Craig Newman
>
>
>
> -----Original Message-----
> From: Michael Doub <mike at doub.com>
> To: How to use LiveCode <use-livecode at lists.runrev.com>
> Sent: Thu, Dec 1, 2011 2:27 pm
> Subject: Re: Custom Property Data Limit?
>
>
> Bob,
>
> Using the GetDataForLine Callback is the technique that I was referring to
> that
> forces you to have a fixed row height.
>
> See:
>
> http://lessons.runrev.com/s/lessons/m/datagrid/l/7341-Displaying-Large-Amounts-of-Data
>
>
> -= Mike
>
>
>
> On 2011-12-01, at 6:45 PM, Bob Sneidar wrote:
>
> > I do not know what that means. At any rate, let me remind everyone that
> sqlYoga produces arrays that are compatible with datagrids, so that a
> simple
> query for all the records or even a subset of records, and then set the
> dgData
> of group "myDataGrid" to theDataA or something of the sort.
> >
> > for updates, you could do something like trap selectionChanged in the
> datagrid
> script (and I think there is also a way to determine what the last
> selected row
> was) so that you can put together an update query whenever the selection
> changes. Just make sure your datagrid and sql columns match up.
> >
> > But even without sqlYoga a loop can be written to parse the cursor out
> to an
> array. That is what sqlYoga does internally anyway. But you would also
> have to
> get a list of the columns in the table so you could set the keys of the
> array
> properly. It's a bit more complicated that way.
> >
> > Bob
> >
> >
> > On Dec 1, 2011, at 1:26 PM, mike at doub.com wrote:
> >
> >> I found that when going to the database approach and directly feeding
> the
> database you are limited to a fixed row height datagrid.
> >>
> >> -= Mike
> >
> >
> > _______________________________________________
> > 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
>
> _______________________________________________
> 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
>
>
> _______________________________________________
> 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>



More information about the Use-livecode mailing list