Well, it's only a case of "I expect ..." so we shouldn't trust my
intuition until we've benchmarked it a bit :-)
Having said that - we will still be using script to iterate over the
keys/elements of the array, so there is likely to be some cost there -
even before we allow sqlite to index some columns.
I've just started looking at it from the performance point of view, and
reduced the time for the simple case in the included test stack by 95%
so it doesn't feel so bad now .... but I'll need to completely rewrite
the main functions/handlers :-(
I'll try to import the data into an sqlite DB and compare against that
too - will report with some numbers tomorrow (and come up with a more
reasonable test case.
Alex.
On 18/04/2018 18:08, Richard Gaskin via use-livecode wrote:
Alex Tweedly wrote:
> I expect the searches etc. would be faster with SQL / memory database
Both use hashed lookups to find data. What would be needed to bring
LC array queries on par with SQLite?
_______________________________________________
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
