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
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 have
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.
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
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]
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
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:
Hi
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?
[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 look at
:[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 into once a week (about 20-30k Rows) And
select from all the time
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 7:57 PM
To: [EMAIL PROTECTED]
Subject: Re: Speeding up Inserts
At 08:55 AM 5/25/2004, you wrote:
Hi All,
Whats
11 matches
Mail list logo