Re: Really slow batch insert??

2013/12/30 13:59 +0200, Cabbar Duzayak We have a basic table, which is something like : (id varchar50, productId varchar50, category varchar50) In this table, ID is the primary key and we have a unique index on (category, productId). And, there is a case where we want to do bulk inser

Re: Really slow batch insert??

Ah, forgot to mention that table is INNODB. On Mon, Dec 30, 2013 at 1:59 PM, Cabbar Duzayak wrote: > Hi, > > > We have a basic table, which is something like : > > > (id varchar50, productId varchar50, category varchar50) > > > In this table, ID is the primary key and we have a unique index on

Really slow batch insert??

Hi, We have a basic table, which is something like : (id varchar50, productId varchar50, category varchar50) In this table, ID is the primary key and we have a unique index on (category, productId). And, there is a case where we want to do bulk inserts (3000 inserts) using: INSERT INTO (id,