Re: Practical samples for table types

[Jeremy Zawodny]

On Tue, May 27, 2003 at 07:50:21AM -0400, Becoming Digital wrote:
>
> MyISAM is the default MySQL table type.  This is the table type of
> choice for tables whose primary activity comes from SELECT
> statements.  There is no need for transaction-safe tables unless
> INSERT, UPDATE, and/or DELETE actions will be performed frequently.
> Remember that with transaction-safe tables comes an increase in the
> amount of system resources needed to use those table types.
> 
> BDB table type is a usable, transaction-safe table type, but it is
> not the most optimized table type in the mix.  BDB tables support
> the basic elements of transactions as well as the AUTOCOMMIT
> variable, but are not as popular or as developed as the InnoDB or
> Gemini types.

Gemini?  I haven't heard that name for a while.  I thought it was
dead.  Is NuSphere still selling their Gemini-enhanced MySQL?

Jeremy
-- 
Jeremy D. Zawodny     |  Perl, Web, MySQL, Linux Magazine, Yahoo!
<Jeremy@stripped>  |  http://jeremy.zawodny.com/

MySQL 4.0.8: up 114 days, processed 3,575,209,651 queries (360/sec. avg)