> -----Original Message----- > From: Adrian Lynch [mailto:[EMAIL PROTECTED] > > Maybe only cache current data? If it's less likely someone will look at last > years entries, exclude them from the cached data. It'll be easiest to wack > it all in there and see how it works out, if you think it might be a problem > then look at ways of trimming the amount you cache.
That's an idea. The way it'll work is you'll have a master page that lists a variety of different events, each with different dates, occurrences (some are once-off, some are weekly, etc). In addition there'll be two miniature calendars on the side of the page with color-coding to state what sort of events are on that day. Visitors will be able to click on an event title to see the detail (article text) and a list of similar events. There will be an archives page for each event type, which will list all past events that are not on the main page. Lastly, there will be a large calendar view (clickable from the mini calendars on the master page) which will display the events for an entire month along with links to the detail page for each one. >From that I was going to cache the processed calendar information and leave the event text in the database. Simply storing that amount of information shouldn't be too much of a burden IMHO. On a related note, I was add icalendar support but when Outlook doesn't support icalendar files properly there's no point. -- Damien McKenna - Web Developer - [EMAIL PROTECTED] The Limu Company - http://www.thelimucompany.com/ - 407-804-1014 #include <stdjoke.h> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:196217 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
