[lierduh]

Originally Posted by Kadence

Tremendous mod

Only problem is the speed. I seem to be getting only about 3,500 posts/hour, whereas it takes under a minute to download that number through NNTP on a newsreader. But I suppose that's probably because of the vBulletin database functions taking up a lot of time, rather than the download of articles itself...?

vB indexes all the words in the post contents, that is why it is very fast to search a term from the post. Whereas a normal news reader usually only index the subject. To find a keyword within the post would basically require a full article scan. I believe the indexing takes up most of the time for importing.

To speed up a bit, one can delete the index for 'msgid' in the post table, and reindex that field with a smaller size. It is quite easy to do with myphpadmin. Just set the size of the index to 10 or 15. That might(according to mysql manual) improve some speed.