On Fri, 28 Feb 2003, Sherwin T. Ang wrote: > Well I guess the best way is to make an insert statement that goes like, > > INSERT INTO table values (3,'S',1,6,'2002-07-15','The Palm Computing > Device',1),(2,'S',6,6,'2002-07-18','Programming for the > Palm',1),(4,'S',5,6,'2002-07-1 > 6','Medical Applications for the Palm Device',1); > > The above query will connect once and insert all 3 records, The method is > called extended insert, and is a much faster method of insert based on the > mysqldump man pages when restoring data back to the database. I > use --extended-insert in my sql dumps.
unfortunately this is not an option in my case. Raw data contains certain errors and this will trigger an error upon insertion, which can be dealt with by the script when I do it 'one at a time'. My question was "what is the fastest way to start the mysql client". Regards, Thomas Spahni -- sql, query > 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" <[EMAIL PROTECTED]> > To: <[EMAIL PROTECTED]> > Sent: Friday, February 28, 2003 8:37 PM > Subject: speeding up mysql client > > > > 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 as > > possible? I'm already using --disable-auto-rehash, but what other > > options could help? > > > > Thomas Spahni --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
