2003 15:21
> To: cmars
> Cc: [EMAIL PROTECTED]
> Subject: Re: 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
ssage-
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.
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
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
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
>
&g
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 need
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 need to improve throughput.
How can I