View source for Digikam/Check Database/uk

<languages />

== Перевірка та оптимізація баз даних digiKam ==
Створено на основі допису у блозі Дмітрія Попова (Dmitri Popov), 19 грудня 2011 року

By default,'''digiKam''' uses two ''SQLite databases'' for storing essential data: ''digikam4.db'' and ''thumbnails-digikam.db''. And to make the application run fast and smoothly, it’s a good idea to check and optimize the databases every now and then. To do this on Ubuntu or its derivatives, you need to install the <tt>sqlite3</tt> package using the <code>sudo apt-get install sqlite3</code> command. Once you’ve done that, back up the digikam4.db and thumbnails-digikam.db databases. Open then the terminal and switch to the directory where the databases are stored. First off, you should check the integrity of both databases using the following commands:

{{Input|1=sqlite3 -line digikam4.db 'pragma integrity_check;'
sqlite3 -line thumbnails-digikam.db 'pragma integrity_check;'}}

If both databases are in order, you should see the message {{Output|1=integrity_check = ok}}  

To optimize the databases, run the two commands below:

{{Input|1-sqlite3 -line digikam4.db 'vacuum;'
sqlite3 -line thumbnails-digikam.db 'vacuum;'}}

Run then the integrity check once again to make sure that everything works properly, and you are done.

[[Category:Graphics]]
[[Category:Photography]]
[[Category:Tutorials]]