multiple xml doc reference performance

[Charlie]

Hi,

I have two xml files, one is about 200M and the second
is  1.5M. I tried to go through the first big file and
check the info in the 2nd file for every iteration, so
it looks like two for loops.

My question is what the better solutions are to make
this kind of query faster. I have some other queries
running on one 400M file within two minutes, but this
query using two smaller files takes much longer.

Thanks for any suggestions,
Chong


      ____________________________________________________________________________________
Fussy? Opinionated? Impossible to please? Perfect.  Join Yahoo!'s user panel and lay it on us. http://surveylink.yahoo.com/gmrs/yahoo_panel_invite.asp?a=7