View Single Post
Old 06-23-2011, 01:10 PM   #20
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


I'm not an expert on DB either, but I think the new indexes can be added now and force a reindex of the db.
Could you post the concrete modifications to the DB?
I can run them on my computer after copying global.db from the DR800.
So we can test the results.

As a second step I will investigate about moving covers to outside the DB.
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
yuri_b is offline   Reply With Quote