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

mySQL - what table type to use?

 [1/6] from: petr::krenzelok::trz::cz at: 6-Aug-2003 13:04


Hi, I just downloaded mySQL and Control Centre app yesterday and I set-it-up under Windows. Well, to be honest, open-source folks still have to learn, how to make it operable more easily, than to struggle with configs and manual directory placements etc. I would like to ask, what type of db you use with mySQL? Is myISAM good for most cases or is any transactional db type (innoDB, BDB) better path to follow? i do care of data consistency, but maybe myISAM is good enough for average news-site or small-portal kind of projects? Thanks a lot, -pekr-

 [2/6] from: matt:blis at: 6-Aug-2003 12:52


Petr, myISAM is good enough for most general cases, and easy enough to maintain. Regards, Matt -- NP: nothing at the moment... Petr Krenzelok wrote:

 [3/6] from: g:santilli:tiscalinet:it at: 6-Aug-2003 15:45


Hi Petr, On Wednesday, August 6, 2003, 1:04:19 PM, you wrote: 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. Regards, Gabriele. -- Gabriele Santilli <[g--santilli--tiscalinet--it]> -- REBOL Programmer Amiga Group Italia sez. L'Aquila --- SOON: http://www.rebol.it/

 [4/6] 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
<<quoted lines omitted: 6>>
> 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

 [5/6] from: g:santilli:tiscalinet:it at: 6-Aug-2003 23:23


Hi Rod, On Wednesday, August 6, 2003, 8:09:32 PM, you wrote: RG> are using a db without transaction support you need to design it RG> differently to get reasonable reliability. Yes, of course, but it depends on what your DB is modeling. Roll-back is important if aborting between queries would leave the DB in an inconsistent state. Transactions are important if your queries require proper serialization. You usually need these features (by "need" I mean "can't live without") only for rather complex databases. In simpler cases (as DBs used for web sites usually are) you can easily (as you say) just write your software differently. Regards, Gabriele. -- Gabriele Santilli <[g--santilli--tiscalinet--it]> -- REBOL Programmer Amiga Group Italia sez. L'Aquila --- SOON: http://www.rebol.it/

 [6/6] from: rgaither:triad:rr at: 6-Aug-2003 17:56


Hi Gabriele,
> RG> are using a db without transaction support you need to design it > RG> differently to get reasonable reliability.
<<quoted lines omitted: 6>>
> usually are) you can easily (as you say) just write your software > differently.
I agree. I just wanted to be sure the point about different design and programming was mentioned, depending on the choice. If you don't do this for either type of database you can find yourself in trouble. Thanks, Rod. Rod Gaither [rgaither--triad--rr--com] Oak Ridge, NC USA

Notes
  • Quoted lines have been omitted from some messages.
    View the message alone to see the lines that have been omitted