I think we already did test this, and the upshot if I recall was that once you
get beyond 2 or 3 recursive queries, the memory DB is much faster.
I think I put up a demo stack demonstrating this on Livecode Share if you want
to have a look.
Bob S
> On Dec 17, 2018, at 18:09 , Tom Glod via
Hi Bob,
Gotta love making custom solutions. Yes, adding tables. In memory
database is pretty genius bob currently I feed my datagrid from an
array.
I am not sure of the line at which a database becomes faster than repeat
with & LiveCode array and a sort function.
maybe thats a good test
I take that back. I updated the arrayToMemoryDB to allow the passing of a table
name, so you can have multiple tables in the memory database.
Bob S
> On Dec 17, 2018, at 08:04 , Bob Sneidar via use-livecode
> wrote:
>
> The upside to using a memory database is speed. The downside is that
Also, I am finding that pushing my data into a memory sqlite database gives me
the ability to easily get just the data I want and sorted just the way I want
(by multiple keys or by calculated results for example). There are two
functions I wrote: arrayToMemoryDB and cursorToArray. Another great
Hi Bob, Thanks, yes thats what I ended up doing as part of the solution
it also helped to read this massive but genius thread :)
http://forums.livecode.com/viewtopic.php?f=8=24945
On Fri, Dec 14, 2018 at 9:31 PM Bob Sneidar via use-livecode <
use-livecode@lists.runrev.com> wrote:
> You
You need to sort the keys of the array and populate accordingly.
put the keys of aData into tKeyList
sort tKeyList numeric descending
repeat for each line tKey in tKeyList
...
Bob S
> On Dec 14, 2018, at 14:10 , Tom Glod via use-livecode
> wrote:
>
> I am using the "dgNumberOfRecords"
I am using the "dgNumberOfRecords" mechanism to populate a grid.
Everything works as expected.
except .I need the last (new) element to show up first and the first
element to show up last.
this is normally achieved by sorting the column, but I cannot sort using
the "large dataset method".