How to make LOAD DB more faster for huge DB? (DBMR2919)
LOAD DB support 2 option, safe and fast, the default is safe.
Set LOAD DB [safe | fast]
If set LOAD DB to SAFE, the database runs in normal mode, if an error occurs during loading ,the load utility rollbacks to the last committed command, and the error messages are displayed in the screen, and writes to the load utility’s log file.
If you want to speed up the LOAD DB process, you can set it to fast mode.
But if you set LOAD DB fast, below tips need to be pay attention.
1. Ensure BACKUP mode off during load process.
DB_BMODE = 0；(default value: 0)
Note: DB_BMODE keyword worked in server side, after change its setting, you need to restart db to apply.
Because "set loaddb fast;" worked under the no journal mode.
Set load fast means that you’re tried to turn on the NO JOURNAL mode, if your turn on backup mode at the same time, ERROR (1002) means was returned that because DBMaker cannot switch the journal mode while db is in BACKUP mode.
dmSQL>set loaddb fast;
2 If any error occurs, it will make the database shut down in no journal mode.
Version: All
Product: Normal/Bundle
Platform: Windows/Linux