Extra database queries

emielvenlo · PR0 Joined: 21 Jan 2007 Posts: 78

One of my forums is becomeming extremely succesfull. With 20.000 to 30.000 visits a day on a 4 month old forum Smile

But the downside is that i have a lot of database problems. The forum reports: could not connect to database. I was wondering how much extra database queries zerodupe+advanced mod rewrite would generate? Is it +- 5% extra or maybe 100% extra?

I am considering migrating to a more expensive host that can more easy cope with the load, but i was just wondering.

HB · phpBB SEO Team Joined: 16 Oct 2006 Posts: 800

Short answer: There's no overhead.

Long answer: OK OK, there are a couple edge cases that can add SQL calls (e.g., generating injected title URLs for search results), but otherwise there are no added SQL calls. As a simplified explanation of the approach, the code caches the required id mapping tables in a global variable in the places that they were already read (e.g., caching the forum id to forum title entries while processing the forums in viewforum.php). The append_sid function in sessions.php is already called to handle last minute session information; the phpBB SEO mods use the fact that it is always called for all URLs to handle URL rewriting, using the cached mapping tables created earlier.

emielvenlo · PR0 Joined: 21 Jan 2007 Posts: 78

Oke, thank you!

Then i just have to find a new host Smile

dcz · Posted: Wed May 23, 2007 11:46 am Post subject: Re: Extra database queries

By the way nice shot, what a growth Shocked

The zero duplicates as well implies some queries under specific conditions.

For example, if you try http://www.phpbb-seo.com/boards/viewforum.php?f=33 the mod will need to know what is forum n°33 title to inject it in the url.

But, these redirection only massively occurs when you change all your url at a time, for example when installing the url rewriting after you forum previously went decently indexed with the regular urls. This phase does not last since bots will "understand" they should now only use the new urls.

So when there is no url migration going on, it's only a rare occurrence when the redirection gets activated. The last post link does imply some extra SQL when followed as well, but we'll soon release the no duplicate mod to fully get rid of posts URL Wink

What is for sure is you really can think about finding a better hosting, because your site growth will require it soon in all cases.

++