If you’d like to help to the documentation, have a look at the Contribute page. Contribute We encourage you to improve the existing documentation by submitting comments, corrections, and patches. #DIGIKAM DATABASES FREE#This eliminates free pages, aligns table data to be contiguous, and otherwise cleans up the database file structure. When you are done with your testing and want to switch to the true photo collection you can always delete all digiKam database files from the folder where it is stored. digiKam API Database schema Use SQliteBrowser to work with SQlite3 database files. The VACUUM command cleans the main database by copying its contents to a temporary database file and reloading the original database file from the copy. Also, frequent inserts, updates, and deletes can cause the information in the database to become fragmented - scrattered out all across the database file rather than clustered together in one place. But in the meantime, the database file might be larger than strictly necessary. This empty space will be reused the next time new information is added to the database. When an object (table, index, or trigger) is dropped from the database, it leaves behind empty space. If more then one database is found in this location, cleanup_digikamdb will optimize every database found in this path and below.įor further explanation, see the following description of the VACUUM command from the sqlite3 website: You can also use MySQL tools to backup and analyze digiKam ’s data. digiKam 7.2. Instead, video tags are stored in the digiKam database on your hard disk. For valid identifiers to use as database names, see Identifier Names. This way, you can use multiple digiKam installations (For instance,on your notebook and PC) to access and manage your photo collections. The Digikam application organizes pictures in an optimized database/library system to ensure the user finds the images they want as quickly as possible. In a final step the database will be optimized by invoking the sqlite command ' VACUUM ' on it. Using MySQL as digiKam ’s database back-end allows you to store the data on a remote server. It then will read the digiKam configuration file and determine the database location. The program will make sure that no instance of digiKam is running, because it is more safe to have no database access during the optimization process. This will, in most cases, lead to a smaller database file size and an increased access speed, because unneeded elements are removed from the database and data is optimized. Cleanup_digikamdb will cleanup and optimize the digiKam database file.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |