FUDforum
Fast Uncompromising Discussions. FUDforum will get your users talking.

Home » FUDforum Development » Bug Reports » Caching content for anonymous users
Show: Today's Messages :: Polls :: Message Navigator
Return to the default flat view Create a new topic Submit Reply
Re: Caching content for anonymous users [message #165792 is a reply to message #165641] Thu, 11 August 2011 14:24 Go to previous messageGo to previous message
eclipsewebmaster is currently offline  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.
[Message index]
 
Read Message
Read Message
Read Message
Read Message
Previous Topic: cannot register
Next Topic: PDF creation error (FUDforum 3.0.3)
Goto Forum:
  

-=] Back to Top [=-
[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sun Dec 01 05:20:52 GMT 2024

Total time taken to generate the page: 0.04124 seconds