NYCPHP Meetup

NYPHP.org

[nycphp-talk] slow php (slow database)

Hans Zaunere lists at zaunere.com
Fri Feb 13 16:36:32 EST 2009


> > Also, it may be that mySQL supports multiple inserts per line, in which
case
> > you can do 10 inserts per round trip.  This will speed it up w/o
requiring
> > you to do to a different command for the bulk copy.
> 
> To the best of my knowledge, you can't send more than one statement at
> a time through the php interface, unless there's something in the
> mysqli extension that allows it.

There is http://us2.php.net/manual/en/mysqli.multi-query.php


...but this is really about this...

http://dev.mysql.com/doc/refman/5.0/en/insert.html

"INSERT statements that use VALUES syntax can insert multiple rows..."

H





More information about the talk mailing list