[Digikam-users] Possible database speedup

[Sami Cokar]

(Try at your own risk)

Once possible way of speeding up digikam is to reduce table fragmentation 
from the database.

*) install sqlite3 (debian flavors: aptitude install sqlite3)
*) play around in digikam to get an idea of how your larger albums perform
*) close digikam

*) cd to the directory where digikam3.db is located
*) cp digikam3.db digikam3.db.bak     (always backup)
*) sqlite3 digikam3.db
inside sqlite, type:
   vacuum;

that's the word "vacuum" followed by a semi-colon.

wait until the prompt returns

*) type ".exit" to quit sqlite3 (  a dot/period/fullstop followed by the 
word exit  )
*) start digikam and play around with your larger albums

--> any speed increases?

And since you do have a backup, you should be able to recover from any 
issues.

concept From a POTN posting:
http://photography-on-the.net/forum/showthread.php?p=2945992#post2945992

and original source:
http://www.adobeforums.com/cgi-bin/webx?14@@.3bc3587a/9

_________________________________________________________________
http://local.live.com/?mkt=en-ca/?v=2&cid=A6D6BDB4586E357F!420