Managing CPU load for calendar update

Hi all,

I am posting on behalf of our web team here, so forgive any part of this that doesn't make sense.

We are trying to make sure that sold out performances are more immediately evident to the naked eye on our Calendar page. Right now, depending on the "type" of sold out that a performance is (ie really  sold out, sold out to Holds, Web MOS has been inactivated, sold out to allocations, etc.), a customer would either need to hover over the performance name for a pop-up pane that would NOT display a Buy Tickets link, or click through to the Reserve page, at which point discovering there are no tickets available for their selected performance.

We are concerned about the CPU load if the page is constantly looking to the db for availability on every performance shown on the calendar.

Has anyone worked out a good solution? Let me know if I can clarify.

thanks,

frannie