Just FYI and hopefully some suggestions...

I've been displaying the default mini calendar on all my pages, cloned and changed to display a custom content type using a CCK date field. Pretty basic stuff.

My site has struggled with performance for over a year, even with minimal users that were all anonymous except for me. My host sent me a nastygram about performance and server resources so I started digging in to see what was causing the problem.

The mini calendar was calling 2 queries that each took more than 8000 ms to complete. I turned off the mini calendar block and voila- my site is responsive and reasonably quick to load.

I know a lot of people use the mini calendar view and I'm now realizing a prior site that I worked on probably had the same issue as we used the mini calendar block extensively for that one as well.

I don't know if there's any way to optimize the query better or if that's just the way it has to be, but I really like having that block and would like to turn it back on if anyone has any suggestions on making it more efficient.

Thanks

Comments

slsonnier’s picture

slsonnier CreditAttribution: slsonnier commented

I have the same issue. Was there a fix?

developer-x’s picture

developer-x CreditAttribution: developer-x commented

Can you paste the specific queries? The performance may be improved with just simply adding indexes.

enkara’s picture

enkara CreditAttribution: enkara commented

Could you please point out wich indexes should we add?

Neslee Canil Pinto’s picture

Neslee Canil Pinto
he/him
Primary language English
CreditAttribution: Neslee Canil Pinto at Specbee commented
Issue summary: View changes
Status: Active » Closed (outdated)

The D6 branch is no longer supported so we're closing this issue. If you think this issue still exists in D7 you can open a new one.