Re: Very slow insert with Innodb

[Vikram Rao]

Yes. Thats a typo.

It is

KEY `Fld1Tbl1` (`Fld1`),
KEY `Fld2Tbl1` (`Fld2`),
KEY `Fld3Tbl1` (`Fld3`)

This is done because lot of select queries run like:

select * from Tbl1 where Fld1 = ? and Fld2 = ?
select * from Tbl1 where Fld1 = ?
select * from Tbl1 where Fld2 = ?
select * from Tbl1 where Fld3 = ?

Having a compound index key would have any issues while selecting above queries?

Each insert will have around 50 rows being inserted. Is it advisable to disabling keys before inserting and enabling once it is inserted?