Re: Memory to Memory INSERTS

2004-06-29 Thread Jeremy Zawodny
On Tue, Jun 29, 2004 at 08:46:35PM -0400, Alejandro Heyworth wrote: > Eric, > > I'm looking for a way to eliminate the construction, transmission, and > parsing of the long multi-row INSERT queries that we are issuing from our > client app. Since we are inserting 200k rows a shot, we're looking

Re: Memory to Memory INSERTS

2004-06-29 Thread Alejandro Heyworth
Eric, I'm looking for a way to eliminate the construction, transmission, and parsing of the long multi-row INSERT queries that we are issuing from our client app. Since we are inserting 200k rows a shot, we're looking for every boost that we can find. * Connecting: (3) [want to use a connect

Re: Memory to Memory INSERTS

2004-06-29 Thread Eric Bergen
cc: > Fax to: > 06/25/2004 03:48 PM Subject: Memory to Memory INSERTS > > > > > Hi! > > I'm looking for a better way to insert large numbers of rows from a client > application that i

Re: Memory to Memory INSERTS

2004-06-29 Thread SGreen
cc: Fax to: 06/25/2004 03:48 PM Subject: Memory t

Re: Memory to Memory INSERTS

2004-06-29 Thread Alejandro Heyworth
Shawn, Very Interesting idea. I definitely want to look into this a bit more. I fear though that the bin-logs might be written first to disk before they are copied over to the replicas. Another member of my team mentioned there might be a way to issue direct MyISAM table INSERTS. She suggested

Memory to Memory INSERTS

2004-06-25 Thread Alejandro Heyworth
Hi! I'm looking for a better way to insert large numbers of rows from a client application that is sampling physical data in real-time. In our case, we are using a C "double hipvalues[100]" cyclical array to buffer our sampled values. We're currently creating large query strings similar to