[osflash] [OT] MyISAM ou InnoDb?

[Arnoud Bos]

innodb is better also for referential integrity enforcing
myISAM is faster for selects though...

Arnoud

-----Oorspronkelijk bericht-----
Van: osflash-bounces at osflash.org [mailto:osflash-bounces at osflash.org] 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" <joao.saleiro at webfuel.pt>
To: "Open Source Flash Mailing List" <osflash at osflash.org>
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
> osflash at osflash.org
> http://osflash.org/mailman/listinfo/osflash_osflash.org 


_______________________________________________
osflash mailing list
osflash at osflash.org
http://osflash.org/mailman/listinfo/osflash_osflash.org