Re: MyISAM or InnoDB?

Go for MyISAM. If I'm correct the performance will be slightly better due to 
the lack of transactional processing. You needn't worry about table sizes 
for the amount of records you are dealing with. MySQL's limitations start 
occurring when your tables become Terabytes, moreover I think its an OS 
filesize limitation and not MySQL's

----- Original Message ----- 
From: "Jorge Bastos" <[email protected]>
To: <[email protected]>
Sent: Friday, March 24, 2006 2:02 PM
Subject: Fw: MyISAM or InnoDB?


> Nobody answered me :-(
>
> Jorge
>
>
> ----- Original Message ----- 
> From: "Jorge Bastos" <[email protected]>
> To: <[email protected]>
> Sent: Wednesday, March 22, 2006 12:40 AM
> Subject: MyISAM or InnoDB?
>
>
> Hi people,
>
> I'd like to ask a thing, with a support for a table with about 500.000 / 
> 700.000 records and another with about 5.000.000/10.000.000
> what would you sugest? MyISAM or InnoDB?
> i don't need any special features that exist in InnoDB, i'm just worried 
> if there's any problem for the tables for the large amount of records.
>
> Jorge Bastos
>
>
> -- 
> MySQL Windows Mailing List
> For list archives: http://lists.mysql.com/win32
> To unsubscribe:    http://lists.mysql.com/[email protected]
> 



-- 
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe:    http://lists.mysql.com/[email protected]