User Tools

Site Tools


audiologger:database-file-on-local-disk

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

audiologger:database-file-on-local-disk [2019/07/09 16:18] (current)
Line 1: Line 1:
 +====== Audio Logger: Move Database File to Local Disk ======
  
 +===== The problem =====
 +
 +Audio Logger keeps a database of all recordings in the file ''​AudioLogger.db''​ inside the slot output directory. This file is regularly updated when recordings are started or stopped.
 +
 +Internally we use [[https://​www.sqlite.org/​|SQLite]] to manage this database file, a small library that implements an SQL database that does not require a server but stores all data in a regular file.
 +
 +**SQLite does not work well over a network share.** In face, the SQLite developers [[https://​www.sqlite.org/​whentouse.html|strongly advice against placing the database file onto a network share]], as it will result in degraded performance or even data loss.
 +
 +===== Solution: Moving the database file =====
 +
 +By default, Audio Logger saves the database file in the same folder as the audio recordings. When you choose a network share for the audio, the database file will be stored on the network share as well, resulting in the problems mentioned above.
 +
 +The solution is to move the database file for each slot onto the local disk of the computer where Audio Logger is running. You need at least version 1.3.3 of Audio Logger.
 +
 +==== Step 1: Locate database file ====
 +
 +The file is called ''​AudioLogger.db''​ and can be found in the slot output folder.
 +
 +==== Step 2: Close Audio Logger ====
 +
 +The following steps will require that Audio Logger is not running.
 +
 +==== Step 3: Move database file ====
 +
 +Choose a location on the local hard disk (e.g. create a folder ''​C:​\AudioLogger''​ - do **not** use a folde protected by UAC, e.g. ''​C:​\Program Files''​!) and move the ''​AudioLoger.db''​ file there. It's OK to rename it when required.
 +
 +==== Step 4: Locate and edit AudioLogger.ini ====
 +
 +The configuration file for Audio Logger is usually found at ''​C:​\ProgramData\mAirList\Audio Logger\AudioLogger.ini''​. Open it in a text editor.
 +
 +==== Step 5: Edit slot configuration ====
 +
 +You will see a section ''​[Slot<​Number>​]''​ for each recording slot, e.g. ''​[Slot0]''​ for the first slot (numbers are 0-based). Inside that section, look for a line like this:
 +
 +  DatabaseFile=
 +  ​
 +And type the full path and name of the database file after you moved it:
 +
 +  DatabaseFile=C:​\AudioLogger\AudioLogger.db
 +  ​
 +Repeat for each slot. Don't forget to save.
 +
 +==== Step 6: Restart Audio Logger ====
 +
 +You can now restart Audio Logger, and it will use the database file in its new location.
audiologger/database-file-on-local-disk.txt ยท Last modified: 2019/07/09 16:18 (external edit)