Glen,
Look at my test results more closely:
Finding the 1st item of the 1st line using direct reference = 3ms
Finding the last item of the last line using direct reference = 440294ms
Finding the -1 item of the 1st line using direct reference = 5ms
Finding the -1 item of the -1 line using direct reference = 733095ms
Finding the first child of the first key = 3ms
Finding the last child of the last key = 3ms
Finding 1st item of 1st line using repeat for each line = 0ms
Finding last item of last line using repeat for each line = 454ms
Using direct reference is always slower than repeat for each, ESPECIALLY if
the data is toward the end.
I would amend Geoff's script to this:
repeat for each line L in the keys of yourArray
if L > 20 then
put L & cr after R
if L > 60 then
exit repeat
end if
end if
end repeat
Don't waste cyling through lines you don't have to.
HTH
On Tue, Feb 21, 2012 at 5:37 PM, Glen Bojsza <gboj...@gmail.com> wrote:
> I was thinking more along the lines (no pun intended) of
>
> - find line number of starting value (for example line 578 )
>
> - find line line number of ending value (for example 12125)
>
> put lines 578 to 12125 into results
>
> Can this be done verses looping through each line since we know the xs
> column is sequentially in order?
>
>
>
> On Tue, Feb 21, 2012 at 1:54 AM, Geoff Canyon Rev <gcanyon+...@gmail.com
> >wrote:
>
> > Depends on how big the list is. Unless there's a faster method than the
> one
> > I used (or you're using slower hardware than I am), you should be okay up
> > to about 100,000 rows using something lik
> > repeat for each line L in the keys of yourArray
> > if L > 20 and L < 60 then put L & cr after R
> > end repeat
> > -- 20 and 60 are your filter values,
> > -- R is your result set
> >
> >
> _______________________________________________
> use-livecode mailing list
> use-livecode@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@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode
