Re: Question re:DB package interaction with MySQL

Daniel Convissor wrote:

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');)

Well you are combining two separate methods. How should autoPrepare() know how many rows you want to insert?

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.

Nothing special, since there is nothing special to do .. see above and I really do not see what MDB2 should do there. Especially since the multi insert syntax is more or less directly opposed to the entire prepared statement idea from a syntax perspective. regards, Lukas