Performance issues in iterative concurrent inserts in mysql 4.0.18

Hi

I am using Mysql 4.0.18 and executing concurrent insert statement.
I am executing this statement in the loop. For first few interation the perofrmace is quite good, the query executes in almost 5 to 6 second (Records being fetched and inserted are near about 80000 to 1,00,000).
But as the no of iterations go on the execution time also increases. It goes upto 2 - 3 mins for a single query?

Can anyone tell me if I'm doing anything wrong?? are there any settings to be done (setting system variables, etc) so that iterative concurrent statements will give higher performace??

re: Performance issues in iterative concurrent inserts in mysql 4.0.18

Hi.

Can we see your code?
Without that we don't really have much to go on.

But based on your description, this sounds like a memory-management problem.
Do you have any data or resources that you are storing per iteration but not releasing before the next one?