MobileRead Forums - View Single Post - Handling a huge number of files on the SD Card

yuri_b · 06-22-2011, 01:20 AM

Hi Marcel
I've red your messages.
I'm today also works on embedded platforms ARM/ARC

, firmware engineer.
I have experience in building and porting GNU compiler, developing data base, wrote several programs that uses Lite SQL (previous job as GUI developer). The speed of SELECT with ORDER must be carefully rechecked, I don't beleive, it works so slowely, it have to be other reason.

Sincerely
Yuri

-----
P.S. Maby those days I will find some time to investigate this.

P.P.S. After looking in global data base creation code I found only one index on file+ directory, so this mean that all sorting done thru creating temporary files or memory, that greatly down speed, the problem not in SQL but rather in usage of SQL. IFAIK we can add indexes on default globaldb and metadata.db, and even on existings global.db to speed up SELECT query

06-22-2011, 01:20 AM	#7
yuri_b Connoisseur Posts: 71 Karma: 592 Join Date: Aug 2010 Device: irex dr800sg DR1000S	Hi Marcel I've red your messages. I'm today also works on embedded platforms ARM/ARC , firmware engineer. I have experience in building and porting GNU compiler, developing data base, wrote several programs that uses Lite SQL (previous job as GUI developer). The speed of SELECT with ORDER must be carefully rechecked, I don't beleive, it works so slowely, it have to be other reason. Sincerely Yuri ----- P.S. Maby those days I will find some time to investigate this. P.P.S. After looking in global data base creation code I found only one index on file+ directory, so this mean that all sorting done thru creating temporary files or memory, that greatly down speed, the problem not in SQL but rather in usage of SQL. IFAIK we can add indexes on default globaldb and metadata.db, and even on existings global.db to speed up SELECT query Last edited by yuri_b; 06-22-2011 at 03:17 AM.