Originally Posted by Iņigo
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
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.