Wade Preston Shearer wrote:
On 2 May 2009, at 10:14, [email protected] wrote:
Giving the DBMS a SELECT ... IN( ... ) list lets the DBMS optimize the
query based on its internal information and cached data. This will
likely be much faster than making one DBMS call inside a PHP loop.
Even considering that I have to use PHP to loop through the XML document
and build the string first?
Yup.
Also, how many values can an IN() hold?
I usually cap it around 1k to 10k values in the IN(), depending on the
rest of the query.
--
justin
http://justinhileman.com
_______________________________________________
UPHPU mailing list
[email protected]
http://uphpu.org/mailman/listinfo/uphpu
IRC: #uphpu on irc.freenode.net
