[REBOL] Re: mySQL - what table type to use?
From: rgaither:triad:rr at: 6-Aug-2003 14:09
Hi Gabriele, Petr,
> PK> I would like to ask, what type of db you use with mySQL? Is myISAM
> PK> for most cases or is any transactional db type (innoDB, BDB)
> better path
> PK> to follow? i do care of data consistency, but maybe myISAM is good
> PK> enough for average news-site or small-portal kind of projects?
> I never had any data loss on any applications in several years of
> use of MyISAM tables. Actually, unless you really need to handle
> complex transactions where roll-back is critical, I don't think
> there's any need for transactions at all.
I have only played with mySQL but agree that myISAM is a
reasonable choice for something like a news-site or small-portal.
I would add some caution though to the statement about roll-back
capabilities being for complex transactions. The key to this part
of the decision is as much based on the application type, and the
way it is programmed than the complexity. When you have a db
with transaction support you design and program one way, if you
are using a db without transaction support you need to design it
differently to get reasonable reliability.
Oak Ridge, NC USA