Mailing List Archive: 49091 messages
  • Home
  • Script library
  • AltME Archive
  • Mailing list
  • Articles Index
  • Site search

[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 > good > 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. FWIW, Rod. Rod Gaither [rgaither--triad--rr--com] 336-644-9247 Oak Ridge, NC USA