I wrote a script that can update a field in a table for multiple records. The script processes each record one at a time in a loop based on the keys dumped into an array.
I had tested the script with a various number of records being updated at a time, but we recently had a problem. We tried to update 53 records at a time (an amount that I had tried on various times and successfully updated), but this time only the first record was updated and the rest were not. Now...
Is it possible that someone was signing in or making a change to their record, that caused the script to not update the remaining records? When someone brings up their profile screen, let's say 5 minutes go by before they hit the submit button with their selections. I believe with transaction capabilities in Oracle and MS Sql, it can be programmed around and in MySql only newer versions can address such issues...
Or is it another problem entirely?
Just wondering about your opinions...
Thanks!
