In fact the query on famille returns only one element. The nested while loop execute only one time. Perhaps there is a better solution...
After reading the different answers, It seems that this problem could be due to performance on the insert after a lot of other insert. (The database grows). It is probably not swizzeling. I'm waiting for the 5.1 ... (100X willl be enougth for me) Thanks a lot for your help. G�rard. "Denver Braughler" <[EMAIL PROTECTED]> a �crit dans le message de news:[EMAIL PROTECTED] > Bill McCormick wrote: > > There are still cases where > > poorly coded work can cause performance issues. > That might be part of the problem here. > I thought I saw a nested query with a loop through all rows. > > > Some of the smaller changes where backported to 5.0.7 and 5.0.8. > > These changes resulted in about a 10X improvement in performance > > in internal testing. > 30 seconds is still a big improvement over 5 minutes.
