Hi!
Sinisa == Sinisa Milivojevic [EMAIL PROTECTED] writes:
Sinisa Jeff Tanner writes:
I running a test on mysql to test its performance of doing a bulk insert
into a table using LOAD DATA INFILE.
The table is simple:
CREAT TABLE test (
valueCHAR(32) NOT NULL PRIMARY KEY
)
I running a test on mysql to test its performance of doing a bulk insert
into a table using LOAD DATA INFILE.
The table is simple:
CREAT TABLE test (
value CHAR(32) NOT NULL PRIMARY KEY
)
The test is simple:
a) clear table
b) time performance of inserting X unique
Jeff Tanner writes:
I running a test on mysql to test its performance of doing a bulk insert
into a table using LOAD DATA INFILE.
The table is simple:
CREAT TABLE test (
valueCHAR(32) NOT NULL PRIMARY KEY
)
The test is simple:
a) clear table
b) time
DELAY_KEY_WRITE=1
Tim.
On Mon, Aug 06, 2001 at 07:36:17AM -0700, Jeff Tanner wrote:
I running a test on mysql to test its performance of doing a bulk insert
into a table using LOAD DATA INFILE.
The table is simple:
CREAT TABLE test (
valueCHAR(32) NOT NULL PRIMARY KEY
)
Tanner
Cc: '[EMAIL PROTECTED]'
Subject: Re: LOAD DATA INFILE performance testing
DELAY_KEY_WRITE=1
Tim.
On Mon, Aug 06, 2001 at 07:36:17AM -0700, Jeff Tanner wrote:
I running a test on mysql to test its performance of doing a bulk insert
into a table using LOAD DATA INFILE.
The table
PROTECTED]]
Sent: Monday, August 06, 2001 8:33 AM
To: [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Subject: Re: LOAD DATA INFILE performance testing
Jeff Tanner writes:
I running a test on mysql to test its performance of doing a bulk insert
into a table using LOAD DATA INFILE.
The table
DELAY_KEY_WRITE=ON by default
Jeff
-Original Message-
From: Tim Bunce [mailto:[EMAIL PROTECTED]]
Sent: Monday, August 06, 2001 9:00 AM
To: Jeff Tanner
Cc: '[EMAIL PROTECTED]'
Subject: Re: LOAD DATA INFILE performance testing
DELAY_KEY_WRITE=1
Tim.
On Mon, Aug 06, 2001 at 07:36:17AM