Lynne,
Running it as a true cron job would be ideal since it can just run for hours. I was under the impression that I couldn't do that with vBulletin. I know how to set up true cron jobs, but how would I set it up such that it will run through vBulletin? Any documentation can help. I wasn't able to find anything that related to my problem via search.
Regarding your question, it actually does grab 1000 new posts each time. We have a flag called "fixed" and that flag is set to 1 for posts that have been corrected. We skip those. The reason why we're doing this is because we want to correct all posts in the database. A lot of posts were posted way back since ~2005 or possibly earlier (I just came on board a few months ago). Our current engine corrects new posts, but we want to correct all the previous posts (~3.2 million) of them. Choosing 1000 would make sense since we want to be done with it at a reasonable time.
I'm looking forward to your help with setting this up as true cron job that will work via vBulletin.
Thank you in advance.
|