At 9:32 AM -0400 6/30/08, Allen Shaw wrote:
You all have any thoughts?
- Allen:
One word -- transactions.
http://dev.mysql.com/doc/refman/5.0/en/ansi-diff-transactions.html
The transaction scheme is one that solves the problems you address.
The theory is simply a record doesn't get updated unless it's certain
that the process will happen.
Here's a tutorial on it:
http://www.devshed.com/c/a/MySQL/Using-Transactions-In-MySQL-Part-1/
Cheers,
tedd
--
-------
http://sperling.com http://ancientstones.com http://earthstones.com
_______________________________________________
New York PHP Community Talk Mailing List
http://lists.nyphp.org/mailman/listinfo/talk
NYPHPCon 2006 Presentations Online
http://www.nyphpcon.com
Show Your Participation in New York PHP
http://www.nyphp.org/show_participation.php
