[lierduh]

Originally Posted by krohnathlonman

Could you give us some more information on this as well as anything else that can speed the import process up... So far I've just been tossing SCSI drives at it and simply waiting LOL

To delete the old index:

ALTER TABLE `post` DROP INDEX `msgid`;

and to add a partial index for msgid:

ALTER TABLE `post` ADD INDEX ( `msgid` ( 10 ) ) ;

10 means instead of indexing the whole length of the field (128), we only index the first 10 charactors. This will reduce the size of the index. The full length index is fastest at the time of retrieving, a partial index means the DB engine needs to read more lines at the time of retrieving but needs less work at writing.

To people who needs to import large amount of posts in one go. I think if you disable the index building process at the time of importing, it will speed up a lot. You can then rebuild the index using the AdminCP. Bear in mind, rebuilding the index takes a VERY long time. The total time used to rebuild the index should be less than the time used to import large amount of messages and build the index at the same time. I have not done this, this is only base on the theory that it is very slow to insert records into a fulltext index table, and it is faster to build the fulltext index after all the insertions are done.

If you do not need to search the imported messages, then disabling the index build will surely speed up the import. To do this, just comment out

build_post_index($postid, $foruminfo);

line in the /include/functions_nntp.php