hi, i need to write an update script that won't update more then 500 at a time with a break of 20 seconds between each load...
Create a for/while loop and use LIMIT 500 in the UPDATE statement. At the end of for/while, add sleep(20).