FindIndex question

[Mike Kerner]

i never heard of it called an "elevator". I anyways heard "thumb"

On Mon, Mar 25, 2024 at 2:08 PM Bob Sneidar via use-livecode <
use-livecode at lists.runrev.com> wrote:

> I’ve thought about that. A temporary memory database would not appear to
> the user to be faster, as the initial query for a large dataset will happen
> all at once during which Livecode would be unresponsive. And if you page
> the queries from the live database, re-storing the data in a memory
> database would just be added time.
>
> You could use send in time to cache forward and backwards a few pages, and
> in that case a memory database could help, but if the user drags the
> elevator box (how many people know what THAT is) then you go back to square
> 1 concerning efficiency.
>
> Bob S
>
>
> > On Mar 25, 2024, at 10:34 AM, Mike Kerner via use-livecode <
> use-livecode at lists.runrev.com> wrote:
> >
> > i would be curious to know if an in-memory sqlite db increases scroll
> speed
> > with dg's.
> > basically, you would live load the dg with pages from the db.
> > i can't imagine that the dg is faster than the pg. everything i've tried
> > with the pg is faster than the dg.
> > just one more reason to resurrect the script compiler and release it.
> >
> > On Mon, Mar 25, 2024 at 11:16 AM Bob Sneidar via use-livecode <
> > use-livecode at lists.runrev.com> wrote:
> >
> >> I wrote a findInArray() function that will convert an array to a memory
> >> based SQL database, and one of the arguments is the SQL query statement
> to
> >> use on the database. I have another called FilterArray() which simply
> >> iterates through the keys to output those matching a criteria.
> >>
> >> Bob S
> >>
> >>> On Mar 24, 2024, at 2:22 PM, Neville Smythe via use-livecode <
> >> use-livecode at lists.runrev.com> wrote:
> >>>
> >>>
> >>>> On 25 Mar 2024, at 3:00 am,Mike Kerner wrote:
> >>>>
> >>>> i don't know if you dove into the code, but it's too early to think
> >> about
> >>>> unpacking this, so  here's the code: ...
> >>>
> >>> Thanks Mike
> >>>
> >>> While I was aware of the optional parameters feature of LC commands I
> >> have never used it I so was unfamiliar with the syntax. The penny had
> never
> >> dropped that the parameter list for a command is just an array, so
> >> evidently you can actually send an array instead of a comma delimited
> list
> >>>
> >>> Which means that you can send FindIndex a single parameter pKeyPairsA
> >> which is an array with alternating colName,searchStr values
> >>>
> >>> Setting up such an array is not particularly convenient for coding
> >> however. My workaround had been to use a custom function hack
> >>>
> >>> function myFindIndex pDataGrid, pKeyPairs
> >>>  — pKeyPairs is a comma delimited list such as
> >> “colname1,str1,colname2,str2,..”
> >>>
> >>>   replace comma with quote & comma & quote in pKeyPairs
> >>>   put “dispatch FindIndex to” && pDataGrid && “with” && quote &
> >> pKeyPairs & quote into tCommandStr
> >>>   do tCommandstr
> >>>  put the result into tFoundIndex
> >>>  ...
> >>>
> >>> A much more elegant (if probably no faster) solution is
> >>>
> >>> function myFindIndex pDataGrid, pKeyPairs
> >>>  — pKeyPairs is a comma delimited list such as
> >> “colname1,str1,colname2,str2,..”
> >>>
> >>>   set the columnDelimiter to comma
> >>>   split pKeyPairs by column
> >>>   dispatch “FindIndex" to pDataGrid with pKeyPairs
> >>>  put the result into tFoundIndex
> >>>  ...
> >>>
> >>>
> >>> BTW, where did you find the source code for DataGrid handlers? I now
> see
> >> how one could write a FindIndices function to return all indices rather
> >> than just the first found … or even a general WHERE  search :-)
> >>>
> >>> Neville Smythe
> >>>
> >>>
> >>>
> >>>
> >>> _______________________________________________
> >>> 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
> >>
> >
> >
> > --
> > On the first day, God created the heavens and the Earth
> > On the second day, God created the oceans.
> > On the third day, God put the animals on hold for a few hours,
> >   and did a little diving.
> > And God said, "This is good."
> > _______________________________________________
> > 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
>


-- 
On the first day, God created the heavens and the Earth
On the second day, God created the oceans.
On the third day, God put the animals on hold for a few hours,
   and did a little diving.
And God said, "This is good."