Quote:
Originally Posted by yuri_b
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
