Re: HELP --- Slow SP

[Hardi OK]

Guys,

So many thanks for you kind help.  I was able to find the culprit, just
adding 1 index i can get as fast as 30 thousands record per hour.  So that I
can proccess 2 million data in about 4 days only.

But now, after my main tables loaded with more than 2 million data (2,9
million), i have another problem with the same SP.  After some time (about
each 25 execution loops), i always got this error message:

"ERROR 1205 (HY000): Lock wait timeout exceeded; try restarting transaction"

How can this be happening since I am the only who is doing anything with the
DB?

Rgds/Hardi