Re: [PHP] What if 1,000 people access the database at one time?

Phil, To start with MySQL tables aren't sorted unless some type of maintenance is taking place, and many of those operations can be done on copies of the tables. Check http://www.mysql.com/doc/T/a/Table_maintenance.html for more information. Given that, I would expect the person maintaining t

[PHP] What if 1,000 people access the database at one time?

So let's say Bill is accessing a MySQL table and is about to UPDATE some information on a particular row. Meanwhile, Al is doing a sort on that same table. Couldn't Al's sorting possibly screw up Bill's updating?? Or does MySQL have some built in functions that prevent this? Thanks! Phil