Description
Is your feature request related to a problem?
When friendly URLs are enabled, the rewriter code calls a stored procedure activeforums_Search_URL with a URL to find out which page to load, forum, topics, specific topic, tags, etc. The code itself is fairly straightforward but the stored procedure is complicated and could use some optimization. Specifically, there are a couple of non-indexed retrievals from the Modules table, but more importantly they logic in the procedure builds up a temp table and then selects from the temp table. Normally this isn't a problem and functionality is correct. However, when site is crawled by bot or search engines (which is good because the friendly urls improve SEO and site popularity), this procedure can be called thousands of times as a crawler works through a large forum instance.
Describe the solution you'd like
A clear and concise description of what you want to happen.
Ideally, replace with route mapping.
Alternatively, investigate possible use of a global temp table or new permanent table, or reducing the load by filtering earlier in the procedure rather than after the temp table is populated. Also look at ways to remove the non-indexed Modules table retrieval but only looking at module for the forums module.
Activity