In http://slashdot.org/article.pl?sid=01/09/13/154222&mode=thread, it is
written:
- Writing and reading to the same innodb MySQL tables can be done since it
does row-level locking. But as load increases, it can start being less than
desirable.
----------------------------------------------------------------------------
---------------------
Question - under heavy load, with 75% reads, 25% writes, what table
structure is fastest at retrieving data?
--
Ed Carp, N7EKG - erc@stripped - 214/341-4420 -
http://www.pobox.com/~erc
Squished Mosquito, Inc.
Internet Applications Development
Escapade Server-Side Scripting Language Development Team
http://www.squishedmosquito.com
Pensacola - Dallas - Dresden - London