We use sqlite3 to Kanboard, in documentation of sqlite you can read:
Actually, SQLite will easily do 50,000 or more INSERT statements per second on an average desktop computer. But it will only do a few dozen transactions per second. Transaction speed is limited by the rotational speed of your disk drive. A transaction normally requires two complete rotations of the disk platter, which on a 7200RPM disk drive limits you to about 60 transactions per second.
So if you can put the file in a RAM Disk the speed will be improved.
$ git clone -b "stable" https://github.com/deajan/osync $ cd osync # bash install.sh # apt-get install inotify-tools # cp /etc/osync/sync.conf.example /etc/osync/kanboard.conf # vim /etc/osync/kanboard.conf
The content of the file can be similar to next, you need to modify INSTANCE_ID, INITIATOR_SYNC_DIR,TARGET_SYNC_DIR:
## Sync job identification INSTANCE_ID="kanboard" ## Directories to synchronize. ## Initiator is the system osync runs on. The initiator directory must be a local path. INITIATOR_SYNC_DIR="/var/www/html/kanboard/ramdisk" ## Target is the system osync synchronizes to (can be the same system as the initiator in case of local sync tasks). The target directory can be a local or remote path. TARGET_SYNC_DIR="/var/www/html/kanboard/syncdatabase" #TARGET_SYNC_DIR="ssh://[email protected]:22//home/git/osync/dir2"
Start the server:
# systemctl start [email protected]