DB recall is quite fast (if you've got a reasonable server infrastructure), it's complex processing of the recalled data that can make for performance bottlenecks. So I'd probably call the calendar up, do the collation, and then store the resulting data in the application scope. You can use that for display, but if you need to display full event details, just go hit the DB again.
The time consuming part of the processing is the collation (I'd imagine), not the actual query of event data, so it doesn't really make sense to cache it. cheers, barneyb On Wed, 23 Feb 2005 17:13:23 -0500, Damien McKenna <[EMAIL PROTECTED]> wrote: > > -----Original Message----- > > From: Bryan F. Hogan [mailto:[EMAIL PROTECTED] > > > > It will depend on the amount of memory you have on your machine. > > That's isn't a problem, there's plenty to spare. > > > I don't think it is wise though to stuff data other than simple > > variables or CFC objects. > > I was thinking of storing the parsed data, i.e. I'd have a file that > would load the data from the database, process it (e.g. collate a > calendar) and store it in the Application scope for faster display as > the visitor loads the page. > > > I would try and find a way to store references to my data instead of > the > > data itself. > > I couldn't see the reason to do that myself. OK, maybe leaving the e.g. > event details in the database while caching the event list, but the > whole point is to cache data rather than having to load and process it > constantly. > > -- > Damien McKenna - Web Developer - [EMAIL PROTECTED] > The Limu Company - http://www.thelimucompany.com/ - 407-804-1014 > #include <stdjoke.h> > -- Barney Boisvert [EMAIL PROTECTED] 360.319.6145 http://www.barneyb.com/ Got Gmail? I have 50 invites. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:196258 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=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
