View Single Post
Old 06-22-2011, 07:42 AM   #9
Mackx
Guru
Mackx is a splendid one to beholdMackx is a splendid one to beholdMackx is a splendid one to beholdMackx is a splendid one to beholdMackx is a splendid one to beholdMackx is a splendid one to beholdMackx is a splendid one to beholdMackx is a splendid one to beholdMackx is a splendid one to beholdMackx is a splendid one to beholdMackx is a splendid one to behold
 
Posts: 998
Karma: 19985
Join Date: Dec 2008
Location: Netherlands
Device: iRex DR1000S
I am not that good with databases. So what is the down-side of adding all these indexes, will they be updated on every change of the database?
I saw that there is already one index: CREATE UNIQUE INDEX file_metadata_i1 ON file_metadata (filename, directory_path). I assumed this would speed-up the normal Books-view already?

Did you do a VACUUM before measuring the size of global.db?
Mackx is offline   Reply With Quote