Re: MSSQL(B-end) to MYSQL(Front-End) -> InnoDB or MyISAM

2006-10-08 Thread Ow Mun Heng
On Mon, 2006-10-09 at 13:02 +0700, Ady Wicaksono wrote: > 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,

Re: MSSQL(B-end) to MYSQL(Front-End) -> InnoDB or MyISAM

2006-10-08 Thread Ady Wicaksono
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

Re: MSSQL(B-end) to MYSQL(Front-End) -> InnoDB or MyISAM

2006-10-08 Thread Ow Mun Heng
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? > > Others... for overall, i prefer innodb :) I know it's t

Re: MSSQL(B-end) to MYSQL(Front-End) -> InnoDB or MyISAM

2006-10-08 Thread Ady Wicaksono
Is your MSSQL data structure contain such foreign key? If yes, my isam is not suitable for you Others... for overall, i prefer innodb :) On 10/8/06, Ow Mun Heng <[EMAIL PROTECTED]> wrote: I'm just curious as to which would have better performance for my needs. backend is a MSSQL server and I

MSSQL(B-end) to MYSQL(Front-End) -> InnoDB or MyISAM

2006-10-08 Thread Ow Mun Heng
I'm just curious as to which would have better performance for my needs. backend is a MSSQL server and I want to replicate it into a MySQL Frontend for user accesses. replication would be done via "mysqlimport/load data infile". I'm thinking of doing the inserts something like ever 5 seconds or s

RE: Large file : InnoDB or MyISAM

2003-06-25 Thread Mike Hillyer
5, 2003 2:30 AM > To: [EMAIL PROTECTED] > Subject: Large file : InnoDB or MyISAM > > > Hi to all, > > I will have to do with a very big file (approx 600 millions > of records). > Which is the best table handler for this king of table : > InnoDB or MyISAM &g

Large file : InnoDB or MyISAM

2003-06-25 Thread JOUANNET, Rodolphe
Hi to all, I will have to do with a very big file (approx 600 millions of records). Which is the best table handler for this king of table : InnoDB or MyISAM (many INSERT and MANY SELECT, no UPDATE - statistics file). Best regards. -- MySQL General Mailing List For list archives: http

InnoDB or MyIsam?

2002-07-05 Thread Konstantin Yotov
Hello! :) I'm wondering which table type is better and why for web project with about 100 000 customers. May be InnoDB gives better query performance? I'm using now MyIsam, but is this better idea to move to InnoDB? Thank you! :) __ Do You Yahoo

Re: InnoDB or MyIsam?

2002-07-05 Thread mos
At 06:28 AM 7/5/2002, you wrote: >Hello! :) > >I'm wondering which table type is better and why for >web project with about 100 000 customers. May be >InnoDB gives better query performance? I'm using now >MyIsam, but is this better idea to move to InnoDB? > >Thank you! :) In addition to Steve's c

RE: InnoDB or MyIsam?

2002-07-05 Thread Steve Bradwell
2002 7:29 AM To: [EMAIL PROTECTED] Subject: InnoDB or MyIsam? Hello! :) I'm wondering which table type is better and why for web project with about 100 000 customers. May be InnoDB gives better query performance? I'm using now MyIsam, but is this better idea to move to