1cleanup_digikamdb(1)                                      cleanup_digikamdb(1)
2
3
4

NAME

6       cleanup_digikamdb - Cleanup the digiKam databases to reduce their sizes
7       and increase access speed
8

SYNOPSIS

10       cleanup_digikamdb [-t] [-T] [-p] [-h]
11

OPTIONS

13       -t     Include thumbnail databases.
14
15       -T     Only cleanup thumbnail databases.
16
17       -p path
18              Specify a different database path.  If the specified path is in‐
19              valid, the entry from the configuration file will be used.
20
21       -h     Show command line options.
22

DESCRIPTION

24       cleanup_digikamdb  will cleanup and optimize the digiKam database file.
25       This will, in most cases, lead to a smaller database file size  and  an
26       increased  access speed, because unneeded elements are removed from the
27       database and data is optimized.
28
29       The program will make sure that no instance of digiKam is running,  be‐
30       cause  it  is more safe to have no database access during the optimiza‐
31       tion process. It then will read the digiKam configuration file and  de‐
32       termine  the  database  location.  In a final step the database will be
33       optimized by invoking the sqlite command 'VACUUM;' on it.  If more then
34       one database is found in this location, cleanup_digikamdb will optimize
35       every database found in this path and below.
36
37       For further explanation, see the following description  of  the  VACUUM
38       command from the sqlite3 website:
39
40       When an object (table, index, or trigger) is dropped from the database,
41       it leaves behind empty space.  This empty space will be reused the next
42       time  new  information  is added to the database.  But in the meantime,
43       the database file might be larger than strictly necessary.  Also,  fre‐
44       quent  inserts,  updates,  and deletes can cause the information in the
45       database to become fragmented - scrattered out all across the  database
46       file rather than clustered together in one place.
47
48       The  VACUUM command cleans the main database by copying its contents to
49       a temporary database file and reloading the original database file from
50       the copy.  This eliminates free pages, aligns table data to be contigu‐
51       ous, and otherwise cleans up the database file structure.
52

AUTHOR

54       cleanup_digikamdb was written by Andi Clemens <andi dot clemens at  gmx
55       dot net>
56
57
58
59cleanup_digikamdb               14 October 2009           cleanup_digikamdb(1)
Impressum