Re: Very slow performance??

[Vincent Chow]

Thanks Mark,

It seems it is much better to pack whatever needs to insert or update into a single sql statement and ship it to the server.

Then I have another question, when I need to update a bunch of rows in a table, would it be better if I just delete the affected rows and reinsert them in a single statement? This way, only 2 statements need to be executed. One for delete existing entries, and another one for reinsert them back.

From what I've read so far, there is a batch update, but someone points out that the driver just does the update one by one, which in this case, back to the original performance that I got.

Also, is there any way to temporarily disable foreign key checking if I choose to do batch delete, and insert?

Probably it is the wrong forum to post this question.......