Re: Data integrity checking w/ PHP & MySQL?

Good morning Chad, I would have to agree with Kyle, the only way I can see is by doing a select after every insert / update / delete. Are they allways insert's ? you could do a fast check (not as accuarate) and just check the count SELECT count(*) FROM product; INSERT INTO product VALUES ('', '', ''); SELECT count(*) FROM product; obviously the second select should be +1 higher. SELECT's are quite fast, when compared to update / insert / delete they are like lightning. You said you didn't use any wrapper's. Thats ok, I would recommend you try and write your own though (if you have time). I don't know your situation in the office, but we were having a problem with sometimes customers data wasnt being saved, I finnally traced the problem back to the fact that others in the office weren't correctly error checking, so I made my own wrappers that forced good error checking and error logging, It only took people using the site like *norm* to find the error. It also makes it easier when converting to another db. Chris Lee Mediawaveonline.com In article <3A2FC737.B69D93C@jerviss.org>, "Kyle Jerviss" <kjj@jerviss.org> 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 > >