Vbseo sitemap kills cpu on my server

Hi all -
I've noticed that vbseo sitemap is a server killer for me. It renders my site unusable when running and eats up the CPU.

Check out how long it takes to run below. I resorted to turning it off but want to use it.

Any suggestions?


Summary:
============================
Forum Display: 4067
Show Thread: 125558
Show Post: 877212
Member Profiles:
Poll Results: 1184
Blog Entries: 412
Blog Tags: 63
Album URLs: 8454
Social Groups URLs: 184
Tag URLs: 4703
Archive: 0

Total Indexed URLs: 1020614
Total Processing Time: 330.92 seconds

Google ping: Successful.
Bing ping: Successful.
Yahoo ping: Successful.
Ask ping: Successful.

What options do you choose to include in your sitemap files ?

Max URLS 20000
show post pages
show thread
forum display
poll results
blog pages (going to turn this one off)
member profile album (ditto)
social groups pages and discussions
tag pages
cms pages
page update frequency show post - yearly
page update frequency member profile - monthly
Page Update Frequency - Forum Display - daily
Page Update Frequency - Poll Results - daily
Page Update Frequency (Default) - Show Thread - daily
Page Update Frequency - Blog Tags - weekly (turning it off)
Page Update Frequency - Album - weekly (turning it off)
Page Update Frequency - Social Groups - weekly
Page Update Frequency - Group Discussions - daily
Page Update Frequency - Group Picture - weekly
Page Update Frequency - Tags - daily
Page Update Frequency - CMS Articles - montly
Smart Frequency for Show Thread Pages - (yes)

(the rest are defaults)

Nothing can be understand from your previous message.

Edited my reply to show settings.

You should not include showpost pages to your sitemap files. You can additionally directly run sitemap generator via a cron task defined by server cron jobs

Thanks - so 'show thread' is better because it includes the posts?

Showpost pages just create duplicate content of showthread pages thats why it is not suggested to include those urls

That's what I thought. Thanks for your help. I turned off the blog options as well. I will post again tomorrow so we can see the difference.

Make sure you deleted your existing sitemap files and regenerate them.

It does not overwrite when generated via scheduled tasks?

It will, but since you will have many less total results now with showpost gone, ie if your task ends at sitemap 5 now, and before it went up to 20, 6-20 may be left on the server. Just log in via ftp and kill them all before running for the first time.

Big big thanks Mert!

MUCH BETTER.
CPU never went over 51%, server load was in the 2's... only lasted 46 seconds.

Summary:
============================
Forum Display: 4152
Show Thread: 127644
Show Post:
Member Profiles:
Poll Results: 1192
Blog Entries:
Blog Tags:
Album URLs:
Social Groups URLs: 184
Tag URLs: 4787
Archive: 0

Total Indexed URLs: 137342
Total Processing Time: 46.25 seconds

Google ping: Successful.
Bing ping: Successful.
Yahoo ping: Successful.
Ask ping: Successful.

Great to hear but as i said , if you want to make things run faster even with lower effect on your server , you can directly run Sitemap Generator task within a server cron task. We added quick instructions on how to do this within Sitemap Generator Readme.html

So you're saying that a server cron job will run this with less footprint than the vbulletin scheduled task?