Data integrity checking w/ PHP & MySQL?
| From: | Chad Day | Date: | Thu, 07 Dec 2000 14:30:44 +0000 |
| Subject: | Data integrity checking w/ PHP & MySQL? | ||
| Groups: | php.db php.general | ||
| Request: | Send a blank email to php-general+get-29137@lists.php.net to get a copy of this message | ||
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