[UPHPU] filter XML content against database

[Wade Preston Shearer]

I have an XML file full of records that match records in a database.  
The XML file contains more records than in the database however. I  
need to read the XML file in, loop through the object, and print our  
each record. I need to filter the XML records by the records in the  
database however; meaning, I only want the records that are also in  
the database. The two ways I have thought to do this are:

1. Query the database on each loop to check if that record exists.

2. Create a comma-separated string of the ID all of the XML records  
and then query the database using the IN() function.


Both see really inefficient. Can anyone suggest a better way?
	
-------------- 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/6d4f1a2a/smime-0001.bin