I agree with Dave. I just suggested Access just for development purposes. If Access doesn't suit you, MySQL will work nicely. I guess depending on which db server you're using, you can also setup another db just for cfusion to dump client variables in. Either way, I know your production server _shouldn't_ be using the registery... hooo boy, do I have stories to tell.
"This one time, in dotcom camp... yeah, our registry killed our dot com for a couple of hours because someone failed to mention that our production server was storing everything into the registry." :) Gotta love ye ol' MetalSite. RIP. Blech. :P ~Todd On Fri, 31 May 2002, Dave Watts wrote: > > Is it still better to switch to an Access DB than the registry? > > I really don't know which is better; I do know that neither is especially > good. (The word "sucks" comes to mind for either one.) The problem with > using Access for client variables is that your database will grow, and grow, > and grow without end. I've seen a case where a 2Gb Access database contained > a couple of hundred rows of client data, and nearly paralyzed the server. > So, I'd say that Access is spectacularly unsuited to this. On the other > hand, the registry isn't where you want to store volatile data, either. > > If you do choose to use Access to store Client variables, you may want to > routinely stop CF, compact your Access db, and restart CF. That's probably > the recommendation I'd make, rather than storing them in the registry. At > least, you don't have to worry about your OS being unusable that way. > > Dave Watts, CTO, Fig Leaf Software > http://www.figleaf.com/ > phone: 202-797-5496 > fax: 202-797-5444 > ______________________________________________________________________ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm ------------------------------------------------------------------------------ To unsubscribe, send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body or visit the list page at www.houseoffusion.com
