On Tue, Jul 08, 2003 at 09:36:11PM -0700, cmars wrote:
I want to insert massive amounts of data in near real-time into a MySQL database.
The data is in a structured binary format, and I have code that parses the data into
logical data structures.
...
How can I load data directly into the
Paul,
Did you try using REPLACE instead of UPDATE/INSERT? Could give you some
more speed enhancement.
Cheers
/rudy
-Original Message-
From: Paul Chvostek [mailto:[EMAIL PROTECTED]
Sent: woensdag 9 juli 2003 15:21
To: cmars
Cc: [EMAIL PROTECTED]
Subject: Re: Bulk loading data
On Tue
-
From: Paul DuBois [mailto:[EMAIL PROTECTED]
Sent: Tuesday, July 08, 2003, 9:46 PM
To: [EMAIL PROTECTED], [EMAIL PROTECTED]
Subject: Re: Bulk loading data
At 21:36 -0700 7/8/03, cmars wrote:
Hi,
I want to insert massive amounts of data in near real-time into a
MySQL database. The data
: Bulk loading data
On Tue, Jul 08, 2003 at 09:36:11PM -0700, cmars wrote:
I want to insert massive amounts of data in near real-time into a
MySQL database. The data is in a structured binary format, and I have
code that parses the data into logical data structures.
...
How can I load
At 21:36 -0700 7/8/03, cmars wrote:
Hi,
I want to insert massive amounts of data in near real-time into a
MySQL database. The data is in a structured binary format, and I
have code that parses the data into logical data structures.
Right now I can load into a MySQL database via ODBC, but I
implement this functionality in my application, or extend
MySQL to do it?
thanks,
casey
-Original Message-
From: Paul DuBois [mailto:[EMAIL PROTECTED]
Sent: Tuesday, July 08, 2003, 9:46 PM
To: [EMAIL PROTECTED], [EMAIL PROTECTED]
Subject: Re: Bulk loading data
At 21:36 -0700 7/8/03