single transaction.
Regards,
Heikki
- Original Message -
From: "Keith Thompson" <[EMAIL PROTECTED]>
To: "Heikki Tuuri" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Thursday, January 22, 2004 4:46 PM
Subject: Re: InnoDB loading: add keys before or after
&g
ql.com/
>- Original Message -
>From: "Mirza" <[EMAIL PROTECTED]>
>Newsgroups: mailing.database.myodbc
>Sent: Thursday, January 22, 2004 11:04 AM
>Subject: Re: InnoDB loading: add keys before or after
>> In theory it is fastest to add indexes first, the
January 22, 2004 11:04 AM
Subject: Re: InnoDB loading: add keys before or after
> In theory it is fastest to add indexes first, then disable it (ALTER
> TABLE x DISABLE KEYS), then add data and, on the end, re-enable keys
> (ALTER TABLE x DISABLE KEYS).
> mirza
>
> Keith Thomps
In theory it is fastest to add indexes first, then disable it (ALTER
TABLE x DISABLE KEYS), then add data and, on the end, re-enable keys
(ALTER TABLE x DISABLE KEYS).
mirza
Keith Thompson wrote:
Hello all,
I need to load a new InnoDB table with about 80 million rows.
With MyISAM I have often foun
Hello all,
I need to load a new InnoDB table with about 80 million rows.
With MyISAM I have often found that it is faster to create
the table without indexes, add all the data, then add the
indexes. Is this true with InnoDB as well, or should I put
my indexes in before loading?
Similarly, I have