View Single Post
Old 06-26-2011, 02:58 AM   #52
yuri_b
Connoisseur
yuri_b will become famous soon enoughyuri_b will become famous soon enoughyuri_b will become famous soon enoughyuri_b will become famous soon enoughyuri_b will become famous soon enoughyuri_b will become famous soon enough
 
Posts: 71
Karma: 592
Join Date: Aug 2010
Device: irex dr800sg DR1000S
Quote:
Originally Posted by Iņigo View Post
Could you attach a diff here please? I can say I'm eager to see it ;-)
Iņigo
Attached.

But wait, it isn't last and checked version, maybe I will change it.

Yura


P.S. As you can see I query only for a few items: file_id, filename, is_directory, author and title, NO thumbnails are loaded, and the most important: the SQL uses index to find all items. It loads an index from DB and uses it to find and fetch all data, so thumbnails shouldn't affect to performance.
Ideally it will load only file_id's for first 10 pages, so there is will be no restrictions for book count. The problem as I wrote already how to fill alpha bar. I still look for it's solution.
Attached Files
File Type: zip diff_ctb.zip (14.6 KB, 430 views)

Last edited by yuri_b; 06-26-2011 at 03:06 AM.
yuri_b is offline   Reply With Quote