One of my forums is becomeming extremely succesfull. With 20.000 to 30.000 visits a day on a 4 month old forum
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.

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.

Oke, thank you!

Then i just have to find a new host

By the way nice shot, what a growth

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


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.

++