[UPHPU] filter XML content against database

[Justin Hileman]

Wade Preston Shearer wrote:
> On 2 May 2009, at 10:14, haas at xmission.com 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