forgive me. i was initially using the perl DBI methods to load. I am not intimately familiar with the inner workings of DBI, but obviously it must be doing something if you say mysql does not support binding variables (i am using 4.0.4). This is significantly faster than creating a new prepared statement for every insert.
I'm now using JDBC, and havne't explored this yet. I'm coming from the Oracle camp, and have only been using mysql for less than a month. so far, i find it very snappy. I do miss the ability to have stored procedures, triggers and views however. jeff Dan Nelson wrote: > > In the last episode (Oct 25), Jeff Mathis said: > > I'll agree to this somewhat: > > > > (1) always bind your variables. whatever code you are using to do your > > inserts, the fewer prepared statements you can make the better. > > > > for example: > > insert into TableName (col1, col2, col2, col4) values (?,?,?,?) > > > > then, once you have a prepared statment, do a loop and insert. > > Note that mysql does not support bind variables. If you think you're > using them, whatever API you are using is filling them in before > sending the statement to mysql. Bind variables do solve quoting > problems, though, so if you use them, know why you're using them :) > > -- > Dan Nelson > [EMAIL PROTECTED] -- Jeff Mathis, Ph.D. 505-995-1434 The Prediction Company [EMAIL PROTECTED] 525 Camino de los Marquez, Ste 6 http://www.predict.com Santa Fe, NM 87505 --------------------------------------------------------------------- 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