> I think we should really find out the capabilities of Mayo's server/host > before we can truly suggest one method over another.
I wouldn't go so far as to say I was suggesting one mechanism over another. I merely pointed out that, in general, you improve the performance of web applications by storing data in application server memory instead of fetching it from the database for each page request. > In high traffic eComm sites I have seen superb performance using the > method described. There are plenty of reasons why you might choose Client variables or other database storage over Session variables. It is certainly possible to build applications that perform acceptably well using any of these approaches. My point was simply that storing data in memory will perform better than storing it in a database, all other things being equal. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ phone: 202-797-5496 fax: 202-797-5444 ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:188955 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