[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