pages problem a lot of queries

I think the problem Permalinks

page and permalinks problem 🙂

http://t31os.wordpress.com/2010/02/18/dont-trash-delete/

http://wajwaj.com/wordpress-permalinks-and-performance.html

————————————–

http://wordpress.org/support/topic/website-works-very-slow?replies=9

@thinqbali telling the truth

I found out the reason,that is because my site has too many pages, about 1270 pages. when wordpress does init work, It calls a method named main(),you can find this method in “wp-includes/class.php” line 488. In this method it calls another method that causes the site so slow, that is “$this->parse_request($query_args);” line 490. this method does some url analysis work. I don’t know exactlly the analysis rules, but the numbers of analysis result is about 14200, and this really wastes a lot of time.

Here is just a small part of the analysis result data, just for your information:
[ngg_tag/([^/]+)/feed/(feed|rdf|rss|rss2|atom)/?$] => index.php?ngg_tag=$matches[1]&feed=$matches[2]
[ngg_tag/([^/]+)/(feed|rdf|rss|rss2|atom)/?$] => index.php?ngg_tag=$matches[1]&feed=$matches[2]
[ngg_tag/([^/]+)/page/?([0-9]{1,})/?$] => index.php?ngg_tag=$matches[1]&paged=$matches[2]
[ngg_tag/([^/]+)/?$] => index.php?ngg_tag=$matches[1]
[robots\.txt$] => index.php?robots=1
[.*wp-atom.php$] => index.php?feed=atom
[.*wp-rdf.php$] => index.php?feed=rdf
[.*wp-rss.php$] => index.php?feed=rss
[.*wp-rss2.php$] => index.php?feed=rss2
[.*wp-feed.php$] => index.php?feed=feed
[.*wp-commentsrss2.php$] => index.php?feed=rss2&withcomments=1
[bali-blog/attachment/([^/]+)/?$] => index.php?attachment=$matches[1]
[bali-blog/attachment/([^/]+)/trackback/?$] => index.php?attachment=$matches[1]&tb=1
[bali-blog/attachment/([^/]+)/feed/(feed|rdf|rss|rss2|atom)/?$] => index.php?attachment=$matches[1]&feed=$matches[2]
[bali-blog/attachment/([^/]+)/(feed|rdf|rss|rss2|atom)/?$] => index.php?attachment=$matches[1]&feed=$matches[2]
[bali-blog/attachment/([^/]+)/comment-page-([0-9]{1,})/?$] => index.php?attachment=$matches[1]&cpage=$matches[2]
[(bali-blog)/trackback/?$] => index.php?pagename=$matches[1]&tb=1
[(bali-blog)/feed/(feed|rdf|rss|rss2|atom)/?$] => index.php?pagename=$matches[1]&feed=$matches[2]
[(bali-blog)/(feed|rdf|rss|rss2|atom)/?$] => index.php?pagename=$matches[1]&feed=$matches[2]
[(bali-blog)/page/?([0-9]{1,})/?$] => index.php?pagename=$matches[1]&paged=$matches[2]
[(bali-blog)/comment-page-([0-9]{1,})/?$] => index.php?pagename=$matches[1]&cpage=$matches[2]
[(bali-blog)(/[0-9]+)?/?$] => index.php?pagename=$matches[1]&page=$matches[2]
[canggu-accomodation-search-results/attachment/([^/]+)/?$] => index.php?attachment=$matches[1]
[canggu-accomodation-search-results/attachment/([^/]+)/trackback/?$] => index.php?attachment=$matches[1]&tb=1
[canggu-accomodation-search-results/attachment/([^/]+)/feed/(feed|rdf|rss|rss2|atom)/?$] => index.php?attachment=$matches[1]&feed=$matches[2]
[canggu-accomodation-search-results/attachment/([^/]+)/(feed|rdf|rss|rss2|atom)/?$] => index.php?attachment=$matches[1]&feed=$matches[2]
[canggu-accomodation-search-results/attachment/([^/]+)/comment-page-([0-9]{1,})/?$] => index.php?attachment=$matches[1]&cpage=$matches[2]
[(canggu-accomodation-search-results)/trackback/?$] => index.php?pagename=$matches[1]&tb=1
[(canggu-accomodation-search-results)/feed/(feed|rdf|rss|rss2|atom)/?$] => index.php?pagename=$matches[1]&feed=$matches[2]
[(canggu-accomodation-search-results)/(feed|rdf|rss|rss2|atom)/?$] => index.php?pagename=$matches[1]&feed=$matches[2]
[(canggu-accomodation-search-results)/page/?([0-9]{1,})/?$] => index.php?pagename=$matches[1]&paged=$matches[2]
[(canggu-accomodation-search-results)/comment-page-([0-9]{1,})/?$] => index.php?pagename=$matches[1]&cpage=$matches[2]
[(canggu-accomodation-search-results)(/[0-9]+)?/?$] => index.php?pagename=$matches[1]&page=$matches[2]

It seems with the growing of our pages, the analysis data will also became more and more, my site will become slower and slower, I don’t know what shall I do now, anybody has any ideas please feel free to tell me,