On 10/9/06, Ow Mun Heng <[EMAIL PROTECTED]> wrote:
On Mon, 2006-10-09 at 11:42 +0700, Ady Wicaksono wrote:
> Is your MSSQL data structure contain such foreign key?
>
> If yes, my isam is not suitable for you
Actually, you know what? I don't really know.
How does one go about checking?
Dump it to SQL, and make sure you know how foreign key SQL syntax
See:
http://www.windowsitlibrary.com/Content/77/12/1.html
>
> Others... for overall, i prefer innodb :)
I know it's transaction safe and all, but not too sure if I need the
extra overhead.
If your concern is fast insert, how fast do you need? is 3000 rows
insert/seconds enough?
if your concern is fast read, tune your innodb buffer, bigger memory
bigger performance :)
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
