Lost connection

Ok seems to happen on the 44 file when doing 20,000 and 21 file when doing 40,000 per file. Anyway to sort this?

Code:

Database error in vBulletin 3.5.3:

Invalid SQL:

                    SELECT p.dateline,p.postid,p.threadid
                    FROM post AS p
                    WHERE p.threadid = 37480
                    ORDER BY p.dateline;

MySQL Error  : Lost connection to MySQL server during query
Error Number : 2013
Date         : Monday, March 6th 2006 @ 08:42:48 AM
Script       : http://www.altnation.com/forums/admincp/cronadmin.php?do=runcron&cronid=26
Referrer     : http://www.altnation.com/forums/admincp/cronadmin.php?do=modify
IP Address   : 86.144.181.212

Hello,

you can setup the system cron job (using crontab) instead of using vB scheduler for sitemap generation.

Found the problem mysql was timing out because we have over 2,000,000 posts and it was taking so long.