Thread: database performance question

Hi all,

I have a question as to whether a database will be able to 'handle' a piece of code (it is a MySQL database i.e. client-server model). The pseudocode:

Code:

    foreach client
        update database with client details;

So, as it iterates through the clients, a simple UPDATE command is executed for each client. My question is, will there be any performance issue with this? Does the database need any kind of break in time between each UPDATE command, or can it handle being bombarded with the UPDATE statements at the high speed of the foreach loop?

My guess is that it can handle it, but I need to be sure and I don't have enough sample data to really test it. I am hoping this is an obvious question which someone can easily confirm, based on their experience.

Sorry, I should have mentioned, I am using the disconnected architecture (i.e. IDBCommand). That being the case, there is no DataTable in memory.

It is just a rapid-fire update of the database with a fresh connection and command established in each iteration of the loop.

Great. That is exactly the answer that I was looking (and hoping) for. I did not want to have to put the thread to sleep each time to give the database time to update, and I don't know anything about caching (yet).

Thanks.