View Single Post
Old 06-23-2011, 10:34 AM   #19
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: 730
Karma: 72743
Join Date: Feb 2008
Location: Here or there
Device: iRex iLiad, iRex DR800S. K4NT. Kobo Aura, Aura One, Libra 2.
Quote:
Originally Posted by yuri_b View Post
It's OK


Quote:
Originally Posted by yuri_b View Post
As I already sad in SQL missed a needed indexes, that's way it works so long.
And add indexes is job for 5 minutes, a much simpler then change a way all system works Lets checks maybe it would be enough?
Ok, we agree

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.
Iņigo is offline   Reply With Quote