Jarle Aase schrieb:

> Is there a way to boost the performance? The database is idle, and while
> importing, performance is the key priority (record-locking,
> transaction-rollbacks and file-integrety/crash-recovery are not required
> until the data are imported).

- Disable the foreign key checks (SET FOREIGN_KEY_CHECKS = 0)
- Create the indices at the end of the import

Regards,
A.

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]

Reply via email to