Re: Speeding up inserts in InnoDB

2010-04-22 Thread Chris W
Sorry I misspoke, I am doing updates not inserts. If I was doing inserts I thought about the multiple record at a time idea but unless there is something I don't know, I don't think you can do that with updates. I will look into turning autocommit off and see what that does. Chris W. Andrew

Re: Speeding up inserts in InnoDB

2010-04-22 Thread Johnny Withers
I'm a little confused.. are the inserts slow, or are the updates slow? It sounds like you mean the updates were going about 50/updates sec. You could speed up the update by adding an index on phoneticcallsign.CallSign. JW On Thu, Apr 22, 2010 at 10:13 AM, Chris W <4rfv...@cox.net> wrote: > I ha

Speeding up inserts in InnoDB

2010-04-22 Thread Chris W
I have a very simple table. CREATE TABLE `hams`.`phoneticcallsign` ( `CallSign` char(6) NOT NULL, `PhoneticCallSign` char(6) NOT NULL, PRIMARY KEY (`CallSign`), KEY `PhoneticIdx` (`PhoneticCallSign`) USING BTREE ) I inserted a little over 1 million records with CallSign = to a value from an

RE: Speeding up Inserts

2004-05-25 Thread mos
e. I use Replace so if the primary/unique column values already exist, it will be replaced. You can also use Ignore to ignore the row when a row already exists with the same unique index/primary key. Mike -Original Message- From: mos [mailto:[EMAIL PROTECTED] Sent: Tuesday, May 25, 2004

RE: Speeding up Inserts

2004-05-25 Thread Amit_Wadhwa
e Regards, Amit -Original Message- From: mos [mailto:[EMAIL PROTECTED] Sent: Tuesday, May 25, 2004 7:57 PM To: [EMAIL PROTECTED] Subject: Re: Speeding up Inserts At 08:55 AM 5/25/2004, you wrote: >Hi All, >Whats the fastest way to speed up inserts? >I have a table which I insert int

Re: Speeding up Inserts

2004-05-25 Thread Egor Egorov
[EMAIL PROTECTED] wrote: > Whats the fastest way to speed up inserts? > I have a table which I insert into once a week (about 20-30k Rows) > And select from all the time... > > Is the only way to speed up inserts to remove indexes? > And to speed up selectes, ...add the indexes again? > Take a l

Re: Speeding up Inserts

2004-05-25 Thread mos
At 08:55 AM 5/25/2004, you wrote: Hi All, Whats the fastest way to speed up inserts? I have a table which I insert into once a week (about 20-30k Rows) And select from all the time... Is the only way to speed up inserts to remove indexes? And to speed up selectes, ...add the indexes again? Regards,

RE: Speeding up Inserts

2004-05-25 Thread Amit_Wadhwa
That fixed it, Thanks! -Original Message- From: Mirza [mailto:[EMAIL PROTECTED] Sent: Tuesday, May 25, 2004 7:46 PM To: [EMAIL PROTECTED] Subject: Re: Speeding up Inserts Use: ALTER TABLE DISABLE KEYS ... inserts here ALTER TABLE ENABLE KEYS mirza [EMAIL PROTECTED] wrote: >

Re: Speeding up Inserts

2004-05-25 Thread Mirza
Use: ALTER TABLE DISABLE KEYS ... inserts here ALTER TABLE ENABLE KEYS mirza [EMAIL PROTECTED] wrote: Hi All, Whats the fastest way to speed up inserts? I have a table which I insert into once a week (about 20-30k Rows) And select from all the time... Is the only way to speed up inserts to re

Re: Speeding up Inserts

2004-05-25 Thread cristi
well, you could try mass insertion... instead of inserting each row one by one -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Speeding up Inserts

2004-05-25 Thread Amit_Wadhwa
Hi All, Whats the fastest way to speed up inserts? I have a table which I insert into once a week (about 20-30k Rows) And select from all the time... Is the only way to speed up inserts to remove indexes? And to speed up selectes, ...add the indexes again? Regards, Amit -- MySQL General Mailing