Jackson Miller wrote:
> On Saturday 16 August 2003 4:41, Hans van Harten wrote:
>> Depending on your exact needs, consider brutal overwrites:
>> LOAD DATA CONCURRENT INFILE '...' REPLACE INTO TABLE
>> Replaces 1 rows within 3.5 s into Innodb running MySQL-max-4.10
>> and WinXP on Celeron /400MH
On Saturday 16 August 2003 4:41, Hans van Harten wrote:
> Depending on your exact needs, consider brutal overwrites:
> LOAD DATA CONCURRENT INFILE '...' REPLACE INTO TABLE
>
> Replaces 1 rows within 3.5 s into Innodb running MySQL-max-4.10 and
> WinXP on Celeron /400MHz/ for me.
Is there a nee
Jackson Miller wrote:
> I need to have a web application be able to import large amounts of
> data (400,000 rows of 10 columns). I know how to script it and have
> it running in the background. However I want to know how I can
> optimize my insert statements to try to speed things up.
For extreme
On 15 Aug 2003 at 16:34, Jackson Miller wrote:
> However I want to know how I can
> optimize my insert statements to try to speed things up.
Have you read this?
http://www.mysql.com/doc/en/Insert_speed.html
--
Keith C. Ivey <[EMAIL PROTECTED]>
Tobacco Documents Online
http://tobaccodocuments.o
I need to have a web application be able to import large amounts of data
(400,000 rows of 10 columns). I know how to script it and have it running in
the background. However I want to know how I can optimize my insert
statements to try to speed things up.
Will it help if I insert multiple row