expiring articles

the program expires the articles by deleting all articles out of the 
server's range in xref_headers table, and after retrieving all the 
newsgroups it does the left outer join of xref_headers with headers 
to get all the articles that fall out of the range in the retention.
that left outer join takes a VERY long time if there's a significant 
amount of headers (a couple million). was that done specifically to 
take into account multiple newsgroup servers? if i have only one, i 
guess the split approach won't make sence anymore, right?

has anybody dealt with this?
also, has anybody tried to optimize ubh for performance? there are 
many points that i've noticed, and if maybe anybody else is 
interested we can share ideas? such as for example using binded mysql 
statements so that instead of 500,000 prepare+execute statements 
(which is what "do" essentially does), we only have one prepare and 
500,000 executes with passed vars

any ideas/suggestions/questions are welcome,
Andrey


------------------------ Yahoo! Groups Sponsor ---------------------~-->
Looking for the latest Free IT White Papers?
Visit SearchSecurity.com to access over 500 white papers.
Get instant access at SearchSecurity.com Today
http://us.click.yahoo.com/_9UKOC/QLNGAA/fzPGAA/IHFolB/TM
---------------------------------------------------------------------~->

To unsubscribe from this group, send an email to:
[email protected]

 

Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/