View Single Post
Old 04-03-2011, 10:13 AM   #13
Iņigo
Guru
Iņigo did not drink the Kool Aid.Iņigo did not drink the Kool Aid.Iņigo did not drink the Kool Aid.Iņigo did not drink the Kool Aid.Iņigo did not drink the Kool Aid.Iņigo did not drink the Kool Aid.Iņigo did not drink the Kool Aid.Iņigo did not drink the Kool Aid.Iņigo did not drink the Kool Aid.Iņigo did not drink the Kool Aid.Iņigo did not drink the Kool Aid.
 
Posts: 712
Karma: 72743
Join Date: Feb 2008
Location: Here or there
Device: iRex iLiad, in love with iRex DR800S. Also a K4NT. Now a Kobo Aura
Quote:
Originally Posted by Mackx View Post
There are two parts, retrieving them from global.db and storing them into a memory structure (and using the huge amount of data). For every kind of sorting, all records in the database need to be queried to be able to sort them all according to the sort-criteria. After that the LIMIT/OFFSET are applied. I am not sure what is causing the longest delay, reading all data from the database or having a lot of items in the internal memory? Some measurements should clear this up.
That's the part I can't understand... whay can we use sqlite SORT, OFFSET and LIMIT clauses?
SELECT xxx FROM yyy WHERE zzz SORTBY sort OFFSET ooo LIMIT lll;?

I took a look at that code some time ago and maybe I can't remember properly...

Quote:
Originally Posted by Mackx View Post
I already took a quick look, it indeed seems easier to program in vala then plain C.
yes, that's the idea


Iņigo
Iņigo is offline   Reply With Quote