The diff is that innodb uses row locks, and MyISAM use table lock for writing.
So MyISAM for heavy select tables, and inno for heavy write . Ah.. and innodb tables uses a lot more space on the disk!! a mean: A LOT MORE On 1/17/07, Arnoud Bos <[EMAIL PROTECTED]> wrote:
innodb is better also for referential integrity enforcing myISAM is faster for selects though... Arnoud -----Oorspronkelijk bericht----- Van: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Namens Infos E-Blokos Verzonden: dinsdag 16 januari 2007 22:46 Aan: Open Source Flash Mailing List Onderwerp: Re: [osflash] [OT] MyISAM ou InnoDb? InnoDb is transactionnal, so better Franck Chionna ----- Original Message ----- From: "João Saleiro" <[EMAIL PROTECTED]> To: "Open Source Flash Mailing List" <[email protected]> Sent: Tuesday, January 16, 2007 4:31 PM Subject: [osflash] [OT] MyISAM ou InnoDb? > Considering: > > One website with hundreds of simultaneous visitors; > SQL operations are 80% selects, 20% changes; > Thousands of registers in different tables; > Relational diagram with about 90 tables, completely connected between > them; > Engine: MySQL; > Situation: Website/RIA > > Which is the right choice for the Storage Engine: MyISQM, InnoDB or other? > > Thank you, > > João Saleiro > > > _______________________________________________ > osflash mailing list > [email protected] > http://osflash.org/mailman/listinfo/osflash_osflash.org _______________________________________________ osflash mailing list [email protected] http://osflash.org/mailman/listinfo/osflash_osflash.org _______________________________________________ osflash mailing list [email protected] http://osflash.org/mailman/listinfo/osflash_osflash.org
-- . m a r c o s a u g u s t o ; .eu vim para confundir e não para explicar!. . . - Chacrinha
_______________________________________________ osflash mailing list [email protected] http://osflash.org/mailman/listinfo/osflash_osflash.org
