|
|
|
As new features and abilities are added to c-treeACE SQL, it is often necessary to update the core SQL system tables with new or modified attributes. When upgrading c-treeACE SQL versions, c-treeACE attempts to detect previous database versions and automatically convert them at startup for seamless migrations.
Recent conversions demonstrated exceptionally long conversion times when converting multiple databases. Internally, c-treeACE SQL completes this process under full transaction control. However, the transactions were not always handled most efficiently. By adjusting transaction logic, conversion times have been substantially improved.
It was observed that the conversion could fail without a logged message. Before conversion, a backup timestamped copy of the database file is made (dbname.fdk). Errors that occur during conversion are now logged to CTSTATUS.FCS. It is recommended to examine the CTSTATUS.FCS status log after a server upgrade and ensure a complete and successful conversion took place.
Note: To disable database conversion at server startup, the c-treeACE SQL configuration keyword SQL_OPTION NO_DB_CONVERSION can be used.
