Re: Bulk loading data

2003-07-09 Thread Paul Chvostek
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

RE: Bulk loading data

2003-07-09 Thread Rudy Metzger
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

Re: Bulk loading data

2003-07-09 Thread Paul DuBois
- 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

Re: Bulk loading data

2003-07-09 Thread Paul Chvostek
: 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

Re: Bulk loading data

2003-07-08 Thread Paul DuBois
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

Re: Bulk loading data

2003-07-08 Thread cmars
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