A Sequentum agent saves all extracted data to an internal database while running. The default internal database is a SQLite file database, and file databases does not perform as well as real databases, such as SQL Server or MySQL. You are likely to see significant performance improvements and lower CPU usage when switching to a real database server depending on your system and the data you're extracting.
We recommend that you change the internal database to SQL Server Express if you don't already have an existing database server. SQL Server Express is a free database server from Microsoft but has a limit of 10GB of storage in a single database. You can download SQL Server Express from this URL:
https://www.microsoft.com/en-us/sql-server/sql-server-editions-express
Read the SQL Server Express documentation to learn how to install and operate the database server.
Once you have installed SQL Server Express and added a database, you can change the internal database from the menu Data > Internal Database Settings:
For example, you can improve performance by choosing SQL Server from the Internal Database drop-down:
[mysqld]
datadir=C:/Program Files/MariaDB 10.3/data
port=3306
innodb_buffer_pool_size=500M
innodb_flush_log_at_trx_commit=0
sync_binlog=0
skip-name-resolve
innodb_lru_scan_depth=100
[client]
port=3306
plugin-dir=C:/Program Files/MariaDB 10.3/lib/plugin
Comments
0 comments