I am doing a iterative calculation and in the last iteration, i update few of my tables. What i am trying to do is , make this update more perfect.
Is it possible for me to do updates in small steps with using LIMIT. i do not find this anywhere mentioned and do not have a idea of my own. say i got 10000 records, i get this count and update in steps of 1000 each time as might be this would prevent from a update table to lock the entire table for long.
My table is innoDB type and i would appreciate some nice examples or pointers in this regard.