> 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
______________________________________________________________________
Your ad could be here. Monies from ads go to support these lists and provide more 
resources for the community. http://www.fusionauthority.com/ads.cfm
------------------------------------------------------------------------------
To unsubscribe, send a message to [EMAIL PROTECTED] with 
'unsubscribe' in the body or visit the list page at www.houseoffusion.com

Reply via email to