If you are experiencing slowdowns on batch insert, one cross-DBMS solution is to drop the indexes on the table, do the inserts, and re-create the indexes. This almost always speeds things up, at the expense of giving up uniqueness (primary key) checks in some DBMS.
| -- |
| Jeff Boes |
| Database Engineer |
| Nexcerpt, Inc. |
|
|
|
...Nexcerpt...Connecting People With Expertise
|