Re: Question re:DB package interaction with MySQL

Hi: On Thu, Feb 23, 2006 at 06:50:50PM -0800, Frank F wrote: > > ...DB will create and send two separate INSERT queries. My question is, > why does DB create two separate queries, when MySQL's capable of combining > multiple INSERTS into a single statement? (i.e. INSERT INTO randtest VALUES > ('12341234', '345782'), ('23423', '0983450934');) Don't know. Individidual inserts is the way it was when I began maintaining the package. Perhaps when DB was first written, extended insert wasn't an option. What does PEAR's new abstraction layer, MDB2, do? If it too does the individual inserts, provide a patch to the MDB2 mysql driver that provides extended inserts. --Dan -- T H E A N A L Y S I S A N D S O L U T I O N S C O M P A N Y data intensive web and database programming http://www.AnalysisAndSolutions.com/ 4015 7th Ave #4, Brooklyn NY 11232 v: 718-854-0335 f: 718-854-0409