Module

Archived
Forum
(read-only)

Sitemap Module

ExpressionEngine 2, ExpressionEngine 3, ExpressionEngine 4, ExpressionEngine 5, ExpressionEngine 6

Back to this add-on's main page
View Other Add-ons From Brian Litzinger

     

Too many pages?

Support (Resolved)

golfbloggercom
golfbloggercom

Is there such a thing as too many pages with this module? I’m using the 1.x version of EE and the latest Sitemap Module upgrade. There are some 8,000 pages on my site and when I go to look at the rendered file, it seems as though it quits about feb of last year.

Is there a way to set it so that it resolves the most recent ones first and works its way back to the original pages (from eight years ago)?

PutYourLightsOn
# 1
PutYourLightsOn

the limit is set to 50,000 by default so not sure why that is happening. you could change the order so that the latest pages are displayed first by changing line 110 in mod.sitemap.php to the following:

$entries $DB->query("SELECT edit_date, entry_date, exp_weblog_titles.entry_id, url_title, weblog_id, exp_category_posts.cat_id, cat_name, cat_url_title, cat_image FROM exp_weblog_titles LEFT JOIN (exp_category_posts, exp_categories) ON exp_weblog_titles.entry_id = exp_category_posts.entry_id AND exp_category_posts.cat_id = exp_categories.cat_id WHERE weblog_id = '$weblog_id' AND exp_weblog_titles.site_id = '".$PREFS->ini('site_id')."' AND status = 'open' AND (expiration_date = 0 OR expiration_date > ".time().") GROUP BY entry_id ORDER BY entry_date DESC LIMIT ".$limit); 
golfbloggercom
# 2
golfbloggercom

Thanks for the fast response. Do you know of any SEO reason why I should not have it in reverse order? Also, it takes a long time to render in my browser. Would that be an issue with the search engines.

PutYourLightsOn
# 3
PutYourLightsOn

the order is irrelevant as the date is specified.

8,000 pages would take a while to render, should be fine with search engines though.