Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SQL Anywhere 10.0.1 » SQL Anywhere Server - SQL Usage » Importing and Exporting Data » Transferring data into and out of databases

Performance aspects of bulk operations Next Page

Data recovery issues for bulk operations


Caution    

You should back up the database before and after using bulk operations mode because your database is not protected against media failure in this mode.

If you are running the database server in bulk operations mode (the -b option), the database server does not perform certain important functions. Specifically:

FunctionImplication
Maintain a transaction logThere is no record of the changes. Each COMMIT causes a checkpoint.
Lock any recordsThere are no serious implications.