Re: Data integrity checking w/ PHP & MySQL?

Just a suggestion, keep the insert and updates as it is. write a flat file every insert and update. At one point, you can take a snap shot of all the inserts/updates made to the table in a flat file and then compare two flat file, leaving the table. This way you are comparing two different sources at two different time and this works. Kyle Jerviss wrote: > Ok, that's it! I'm going to write a traffic-whore site like this, too. > :) > > You could SELECT their data, update it like you do now, then reSELECT it > and compare it to their old score for a quick sanity check. Also, > locking the tables might help, but would probably kill your > performance. Post (or send me) your update code and I'll take a look. > > Chad Day wrote: > > > > I've run into some problems on my high traffic site, bangable.com, with what > > appears to be data integrity in MySQL, and was wondering if there are any > > checks I can do in PHP to validate that the right information was updated. > > > > I have a ton of inserts/selects going on.. in little over a day the number > > of queries has reached 1 million. This is an amihotornot type site, what > > happens is the user votes on a picture, that rating/# of votes is updated in > > the DB, the persons IP thrown into a database, then moves onto the next > > picture.. I've gotten a few reports of people who have had like 600 votes > > then all of a sudden they drop to like 27 (or some other random #) or their > > score changes, or some combination of the 2. I've only had about half a > > dozen reported cases of this, and half a dozen in several million queries is > > pretty good, but it reflects badly on the integrity of the system and I need > > to correct that. > > > > Is there any way I can code in a check in PHP to see if it got updated > > correctly without inducing too much overhead? While searching around the > > net this morning for data integrity in MySQL, what I basically saw was the > > check needs to be coded in the programming language. If anyone has > > recommendations on how to do this, I would appreciate it. I don't want to > > switch over to another DB unless there's no solution, as I didn't use a db > > wrapper and changing all those database calls would really suck. > > > > Thanks, > > Chad Day > > > > When I speak german... I think german in my head... but like...Do skript > > kiddies see a w40l3 8uncha 1's and 0's and 3's and 4's and 7's in > > their > > h34d'5 w43n t43y R +a1k1n6 ? -- SirStanley > > > > -- > > PHP General Mailing List (http://www.php.net/) > > To unsubscribe, e-mail: php-general-unsubscribe@lists.php.net > > For additional commands, e-mail: php-general-help@lists.php.net > > To contact the list administrators, e-mail: php-list-admin@lists.php.net > > -- > PHP General Mailing List (http://www.php.net/) > To unsubscribe, e-mail: php-general-unsubscribe@lists.php.net > For additional commands, e-mail: php-general-help@lists.php.net > To contact the list administrators, e-mail: php-list-admin@lists.php.net