<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html; charset=ISO-8859-1"
http-equiv="Content-Type">
<title></title>
</head>
<body bgcolor="#ffffff" text="#000000">
Hi,<br>
<br>
Was this action:<br>
<br>
sqlite3 -line digikam4.db 'vacuum;' <br>
<br>
supposed to delete the ¨thumbnails-digikam.db¨ or is it an accident?<br>
<br>
Rinus<br>
<br>
<br>
Op 13-09-11 14:47, sleepless schreef:
<blockquote cite="mid:4E6F50F0.6060605@hetnet.nl" type="cite">
<meta content="text/html; charset=ISO-8859-1"
http-equiv="Content-Type">
<title></title>
Thanks to the lord I had the patience to wait for an answer, and
thanks to Jean-Francois for the reply. I could not have hoped for
a better one.<br>
<br>
To be continued.<br>
<br>
Have a nice day,<br>
Rinus<br>
<br>
Op 13-09-11 14:10, Jean-Francois schreef:
<blockquote
cite="mid:alpine.LNX.2.00.1109131342060.19606@ian.victoria.net"
type="cite"> <br>
On Tue, 13 Sep 2011, Rinus Bakker wrote: <br>
<br>
<blockquote type="cite">I was suspicious about the db being
broken and was hoping for that (it can <br>
be fixed) and was fearing that (it cause an awfull lot of
work) <br>
Putting the answers of Gilles and Remco together makes me even
more <br>
suspicious about that scenario. <br>
<br>
That´s why I came with this question a while ago: <br>
I suppose that the db becomes more and more messy by adding,
removing and <br>
readding etc etc, I wonder if someone knows if and if, how it
is possible to <br>
optimize the db in order to have quicker search capabillity. <br>
A few filtering actions can make it quite unresponsive. <br>
</blockquote>
<br>
Good guess. All databases systems, be it SQLite, MySQL, Oracle,
PostgreSQL, etc., get messy and fragmented as time goes by. <br>
And that's why all database software provide a "vacuum"
function, to do <br>
cleanup tasks, reorganize tables and indexes, remove deleted
tuples, etc. <br>
<br>
It's a good practice to do such cleanup from time to time. <br>
(Time to time may be every night for huge professional
databases, or <br>
once or twice a month for a user level database as digiKam DB.)
<br>
<br>
<blockquote type="cite">and with this question: <br>
Does anyone know if this <br>
cleanup_digikamdb.1 by Andy Clemens <br>
is still valid to use with current digikam db? <br>
<br>
And any ideas what to do with that cleanup_digikamdb.1 file? <br>
</blockquote>
<br>
Cleanup_digikam doesn't nothing else than issuing "vacuum"
commands. <br>
The extra is that it checks that no active DB connection is
running, <br>
because it's not possible to do vacuum tasks while an
application is <br>
connected and working with the database. <br>
<br>
But you don't need cleanup_digikam if you have the SQLlite3
package <br>
installed, just use the sqlite3 command line client program. <br>
<br>
- Close any running digiKam program <br>
- Go into your digiKam base directory and backup your
digikam4.db file. <br>
- From command line run the following : <br>
sqlite3 -line digikam4.db 'vacuum;' <br>
<br>
That's all and that's mostly what cleanup_digikam does. <br>
<br>
You can also run some checks, e.g. : <br>
sqlite3 -line digikam4.db 'pragma integrity_check;' <br>
<br>
and, hopefully, get a message : <br>
integrity_check = ok <br>
<br>
Tuning a database performance is a bit more complicated because
you need <br>
to know what kind of performance parameter may be affected. <br>
SQLite3 has a number of tuning parameters, see the documentation
: <br>
<a moz-do-not-send="true" class="moz-txt-link-freetext"
href="http://www.sqlite.org/pragma.html">http://www.sqlite.org/pragma.html</a>
<br>
<br>
Maybe, moving temporary storage from disk to computer memory may
help <br>
about performance : <br>
sqlite3 -line digikam4.db 'pragma temp_store = 2;' <br>
(That's the only "tuning" I did on my digikam DB) <br>
<br>
Note that doing such DB maintenance tasks with the SQLite3
command line <br>
program is independant of such or such digiKam version. It's
*the* program <br>
packaged with *the* sqlite library used by digiKam. So it knowns
perfectly <br>
well what should a SQLite db look like, what is correct or not.
<br>
If integrity checks are ok, you can trust that. <br>
<br>
Cheers, <br>
<br>
Jean-François <br>
<pre wrap=""><fieldset class="mimeAttachmentHeader"></fieldset>
_______________________________________________
Digikam-users mailing list
<a moz-do-not-send="true" class="moz-txt-link-abbreviated" href="mailto:Digikam-users@kde.org">Digikam-users@kde.org</a>
<a moz-do-not-send="true" class="moz-txt-link-freetext" href="https://mail.kde.org/mailman/listinfo/digikam-users">https://mail.kde.org/mailman/listinfo/digikam-users</a>
</pre>
</blockquote>
<br>
<pre wrap="">
<fieldset class="mimeAttachmentHeader"></fieldset>
_______________________________________________
Digikam-users mailing list
<a class="moz-txt-link-abbreviated" href="mailto:Digikam-users@kde.org">Digikam-users@kde.org</a>
<a class="moz-txt-link-freetext" href="https://mail.kde.org/mailman/listinfo/digikam-users">https://mail.kde.org/mailman/listinfo/digikam-users</a>
</pre>
</blockquote>
<br>
</body>
</html>