Sitemap Total Processing Time: 345,688.13 seconds

Since installing vB4.0.x and updating vBSEOSitemap, I've been having issues. Previously it took about 700 seconds to run the sitemap, but now it takes much longer. The last run took 345,688 seconds! (Yes, 4 days!).

I've rechecked everything, but I can't figure out the problem. Does anyone have an idea of what may be happening? Thanks.

Please make sure you are using sitemap 2.6 beta2. If you are and its still taking 4 days to complete, you need to either add resources to your server (memory_limit in php.ini) or trim sections from being included in the sitemap itself so it runs faster.

Hi Brian - the earlier version ran fine and I've made no changes to the server backend. I already increased memory_limit when I first installed it a few years back, but I'll double check it in case something changed it for some reason.

What all are you including in the sitemap?

I've turned off "Show Posts" and it is only doing Forum Display, Show Thread, Profiles and Poll. Total 468,496 URLs in latest run, taking 345,657.25 seconds.

It only took a 15-20 minutes before the upgrade, and that included show post pages too.

If it fails to complete the first time, it will tach on the total time until it runs again the next day. It is not runnning for that entire period of time.

You may need to increase your php memory_limit in php.ini or your wait_timeout setting in my.cnf and then restart the appropriate services.

I've increased greatly memory_limit and wait_timeout settings (and restarted services), but it is still not running properly.

I'm going to remove the software and reinstall from scratch, just in case.

I've reinstalled and it is still doing it.

I'm keeping an eye on the files it produces and if I tell it to run, it will produce around 14 archive files and stop. If I rerun it, it will create 14 more.... I've rerun it until it finishes and does them all (a total of 48 files). Not can't see what it issue is, please help.

You need more resources for the sitemap to complete in one shot, you or you need to trim the sitemap included sections.

increasing wait_timeout in my.cnf and memory_limit max_execution_time settings in php.ini will allow the script to run longer.

Removing sections that are not necessary (basically everything but forumdisplay and showthread, and the cms) will also help it to run faster.

I've trimmed it right back already - pretty much just CMS, foruumdisplay (4.5 million posts) and userprofiles. It ran fine with even showposts before I upgraded to vbulletin4. I'll adjust max_execution_time in addition to the others.

Based on the fact I have 4.5 million posts, what would you recommend I set wait_timeout, memory_limit and max_execution_time to?

Correct settings for those have a lot to do with your hardware specs as well. What kind of server are you running?

Quad 2.4ghz AMD, 4GB DDR2 Ram, 2x SATA HDs.

i'd suggest
wait_timeout = 240
memory_limit = 64M
max_Execution_time = 30