Digikam/Check Database/da: Difference between revisions

From KDE Wiki Sandbox
(Importing a new version from external source)
(Updating to match new version of source page)
Line 4: Line 4:
Fra Dmitri Popovs blog, 19. December 2011
Fra Dmitri Popovs blog, 19. December 2011


Som standard bruger '''digiKam''' to ''SQLite databaser'' til at gemme vigtige data: ''digikam4.db'' og ''thumbnails-digikam.db''. For at få programmet til at køre hurtigere og uden hakken er det en god ide at tjekke og optimisere databaserne en gang i mellem. Ubuntu og dens afledede skal du installere pakken <tt>sqlite3</tt> ved hjælp af kommandoen <code>sudo apt-get install sqlite3</code>. Når du har gjort det, så lav en backup af databaserne digikam4.db og thumbnails-digikam.db. Åbn så terminalen og gå til den mappe, hvor databaserne gemmes. Først bør du tjekke begge databasers integritet ved hjælp af følgende kommandoer:
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;'
{{Input|1=sqlite3 -line digikam4.db 'pragma integrity_check;'

Revision as of 13:00, 4 July 2019

Tjek og optimér digiKams database

Fra Dmitri Popovs blog, 19. December 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 sqlite3 package using the sudo apt-get install sqlite3 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:

sqlite3 -line digikam4.db 'pragma integrity_check;'
sqlite3 -line thumbnails-digikam.db 'pragma integrity_check;'

Hvis begge databaser er i orden, så skulle du få beskeden

integrity_check = ok

For a optimisere databeserne skal du køre følgende to kommandoer:

1-sqlite3 -line digikam4.db 'vacuum;'
sqlite3 -line thumbnails-digikam.db 'vacuum;'

Kør så integritetstjekket igen for at sikre dig, at alting virker korrekt; så er du færdig.