FUDforum: Bug Reports » Caching content for anonymous users

Home » FUDforum Development » Bug Reports » Caching content for anonymous users

Show: Today's Messages :: Polls :: Message Navigator

Re: Caching content for anonymous users [message #165792 is a reply to message #165641]

Thu, 11 August 2011 14:24

eclipsewebmaster

Messages: 46
Registered: November 2009
Location: Ottawa, Ontario, Canada

Karma:

Member

I can see some potential solutions:

a) break the query down into smaller queries to not confuse the MySQL query optimizer

b) find a way to stop writing frequently to tables that need to be read (ie, post counts and view counts are preventing some queries from being cached)

c) cache the "Unanswered" content for anonymous users, since search engines can bang on them quite hard

In the short term, a) is perhaps the easiest to implement. I'll take a look at it when I get a chance, but for the time being, I may need to forbid the Unanswered content at the Apache level, since this query is a huge DoS waiting to happen.

Report message to a moderator

[Message index]

		Caching content for anonymous users By: eclipsewebmaster on Fri, 29 July 2011 10:46
		Re: Caching content for anonymous users By: eclipsewebmaster on Thu, 11 August 2011 14:24
		Re: Caching content for anonymous users By: naudefj on Fri, 12 August 2011 12:31
		Re: Caching content for anonymous users By: naudefj on Mon, 17 October 2011 10:03

Previous Topic:	cannot register
Next Topic:	PDF creation error (FUDforum 3.0.3)

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Nov 28 15:32:06 GMT 2024

Total time taken to generate the page: 0.03687 seconds