Fw: MyISAM or InnoDB?

Nobody answered me :-(

Jorge


----- Original Message -----
From: "Jorge Bastos"
To:
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/win32?unsub=gcdmw-win32@m.gmane.org

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"
To:
Sent: Friday, March 24, 2006 2:02 PM
Subject: Fw: MyISAM or InnoDB?


> Nobody answered me :-(
>
> Jorge
>
>
> ----- Original Message -----
> From: "Jorge Bastos"
> To:
> 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/win32?unsub=greg@i-online.co.za
>



--
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe: http://lists.mysql.com/win32?unsub=gcdmw-win32@m.gmane.org