[UPHPU] filter XML content against database

[Wade Preston Shearer]

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?

Also, how many values can an IN() hold?

-------------- next part --------------
A non-text attachment was scrubbed...
Name: smime.p7s
Type: application/pkcs7-signature
Size: 2431 bytes
Desc: not available
Url : http://uphpu.org/pipermail/uphpu/attachments/20090502/ff3792b6/smime.bin