[EventCalendar] PRUNING the plugin

[Hoboken411]

Hehe.. not really, I've been going nuts studying why this is causing issues.
I don't know how many other high-traffic sites use EC3, but it's becoming
nerve-wracking.

 

I have all possible caches on my dedicated server. WP-cache, zend optimizer,
plugin output cache (for some plugins), php_speedy (relatively new) Varnish
and more.. I've tweaked the living daylights out of my site (still more to
go.. on the my.cnf and httpd.conf and the php.ini end.. fine tuning more or
less) and the one slow query is the EC3.

 

I have a guy looking at possibly modifying the code where it caches the
output once per day (that's all I need) and re-runs the query then. Because
often times throughout the day, my server crawls for a few minutes while it
performs giant MySQL queries for EC3. 


There should really be an option in the plugin to determine how often the
query should run. Especially if you only have about 50 or so future dates
(all day events). 

 

 

From: eventcalendar-bounces at firetree.net
[mailto:eventcalendar-bounces at firetree.net] On Behalf Of Mark Naylor
Sent: Tuesday, March 11, 2008 5:34 AM
To: Support for EventCalendar plugin
Subject: RE: [EventCalendar] PRUNING the plugin

 

Hi Hoboken,

Part of the problem with no response is when you sound very knowledgeable
about table joins etc, people think your knowledge is greater than theirs...

I have no idea what you are talking about.

However, going for the obvious first, have you tried wp-cache?
http://wordpress.org/extend/plugins/wp-super-cache/

If all the queries for ec3 are the same, then they will only get run once?

Good luck

Mark

 

  _____  

From: eventcalendar-bounces at firetree.net
[mailto:eventcalendar-bounces at firetree.net] On Behalf Of Hoboken411
Sent: 11 March 2008 02:56
To: 'Support for EventCalendar plugin'
Subject: [EventCalendar] PRUNING the plugin

Hello everyone again. I'm going to try another angle for my SLOW QUERIES
post, which hasn't seen a response yet..

 

I only use EC3 in a limited way: Just a sidebar list of the upcoming events
for the next 10, or maybe 14 days. It should be updated once a day (at
5:30am).. very simple right?

 

Is it possible to prune out the rest of the functionality, such as the month
view and anything else that may cause heavy MySQL usage?

 

I understand it needs to make joins when creating the wp_ec3_schedule table,
but is it necessary to have all these queries since the table is static for
the most part?

 

My site is in desperate need to performance enhancement. 

 

Any suggestions would be so so welcome.

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://penguin.firetree.net/pipermail/eventcalendar/attachments/20080311/be59d0c2/attachment.htm