On Sat, Sep 15, 2001 at 01:12:31AM -0500, Ed Carp wrote:
>
> 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.
Heh. I hope that you don't consider slashdot an authoritative
source. :-)
> Question - under heavy load, with 75% reads, 25% writes, what table
> structure is fastest at retrieving data?
It depends.
What sort of indexes do you need? How much data? Whart sort of
columns? Are the writes INSERTs, REPLACEs, or UPDATEs?
The easiest way is to benchmark it and see for yourself. You may find
that MyISAM is the fastest. Or maybe InnoDB. Or maybe BDB.
Jeremy
--
Jeremy D. Zawodny, <[EMAIL PROTECTED]>
Technical Yahoo - Yahoo Finance
Desk: (408) 349-7878 Fax: (408) 349-5454 Cell: (408) 685-5936
MySQL 3.23.41-max: up 10 days, processed 184,510,505 queries (213/sec. avg)
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
