View Single Post
Old 06-23-2011, 12:51 PM   #21
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 yuri_b View Post
What I did:

1) copy global.db in my PC
2) I have sqlite3.exe already so I just execute those commands:
3) sqlite3.exe global.db
4) in opened sqlite shell enter those commands:
create index filename_index on file_metadata(filename,tag);
create index title_index on file_metadata(title,tag);
create index author_index on file_metadata(author,tag);
create index type_index on file_metadata(file_type,tag);
create index size_index on file_metadata(file_size,tag);
create index date_added_index on file_metadata(file_time_added,tag);
create index time_viewed_index on file_metadata(file_time_lastread,tag);

5) enter: .quit
to exit
6) copy global.db back to device.

Right now I don't have all books on my IREX, so find backup and restore those ~3000 files SD will take a while


Moreover, as I sad, in case missed global.db IREX copy one empty from some place, so we can just generate one empty with all indexes, and place it as template on this location.

Sincerely
Yura
Tested on my ~4k books global.db. Same speed, maybe even a bit slower
Iņigo is offline   Reply With Quote