Question:
When I try to do a simple insert in a table with 25,000 records, it takes a long time do execute. In the same database for a table with 2,000 records, it’s immediate.
Why is this?
Answer:
Does that table have an index or two on it?
Are there any locks being thrown before you get done, such as from people doing select on it?
Try to break your insert down into smaller groups and commit them as you go. I think this will lighten the overhead you’re incurring.
