brokentwig
Forum Replies Created
-
So photocrati, there is no alternative to
album id = 0? How can we display all albums on one page?Forum: Plugins
In reply to: [Subscribe To Comments Reloaded] Only works when logged inAnyone?
I’d love to see some of this for nginx.
It’s already set to 20. The problem is the first event scheduled is 2 weeks out. This isn’t about how many items it displays, but how far out it looks.
I just updated ot the lastest version, and still the Agenda doesn’t go out more than a few days. Is there a setting I’m missing or something? If it’s the next major release, is there somewhere in the code I can tweak this?
Forum: Installing WordPress
In reply to: Super Cache adding // to home locationWhat even makes this weirder, this problem only occurs when not using the www. infront of the URL. In fact, using http://www.domain.com just once, clears the problem up. All subsequent domain.com navigations appear correctly. WTF? This one has me stumped.
Forum: Installing WordPress
In reply to: Super Cache adding // to home locationNote: There is no double slashes when navigating directly to http://www.domain.com/blog/, or any other location on the site, but only when nagivating to http://www.domain.com. It’s jacking up Analytics.
Cool. Would you mind posting a link of your alpha version?
Hector, it appears the problem with the query is the INTERVAL function. I took Alex’s query and changed:
AND wp_popularpostsdatacache.day >= '2012-04-25' - INTERVAL 30 DAYwith
AND wp_popularpostsdatacache.day >= '2012-04-25' AND wp_popularpostsdatacache.day <= '2012-05-25'The query time went from 1.5 – 3.0 seconds down to .009 – .1 seconds. I tested it about 20 times with the same results. I couldn’t find any concensus on the Internets that the INTERVAL function in MySQL is heavy, but it appears to be in this query. I looked through your plugin and this should be an easy fix using the ADDDATE() function.
Using the ADDDATE() function under testing, I was getting .05 seconds average query time.
$range = $table."cache.day >= '".gmdate("Y-m-d")."' AND ".$table."cache.day <= ADDDATE('".gmdate("Y-m-d")."', INTERVAL 30 DAY)";