Re: speeding up mysql client

2003-02-28 Thread Thomas Spahni
Systems Administrator > Tridel Technologies Incorporated > http://www.tridel.net > > > - Original Message - > From: "Thomas Spahni" <[EMAIL PROTECTED]> > To: <[EMAIL PROTECTED]> > Sent: Friday, February 28, 2003 8:37 PM > Subject: speeding up

Re: speeding up mysql client

2003-02-28 Thread Sherwin T. Ang
e --extended-insert in my sql dumps. am not sure if LOAD DATA INFILE is much faster, well on raw data i guess it is. Respectfully yours, Sherwin T. Ang Systems Administrator Tridel Technologies Incorporated http://www.tridel.net - Original Message - From: "Thomas Spahni" <

speeding up mysql client

2003-02-28 Thread Thomas Spahni
Hi everyone, I'm calling the mysql client from a bash shell script in a loop. It's doing one INSERT query each time. I'm aware that there is some overhead in this procedure, because the client has to connect to the server each time. Question: what are the recommended options to make this as fast