RE: Client Variable DB storage
I broke out quite a few clients into individual db's. Wasn't worth the trouble and no noticeable performance gain. Reconsolidated most of them later on. Unless you have a special need - like a client who needs a special expiration period. Then its a real handy thing to do. --- Matt Robertson[EMAIL PROTECTED] MSB Designs, Inc., www.mysecretbase.com --- -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Tuesday, June 04, 2002 11:32 AM To: CF-Talk Subject: Client Variable DB storage On page 549 of Forta's CF 5 book he outlines how to store client vars in a DB. Step 1 reads "If you want, you can use an existing database, but we recommend hat you use a fresh, dedicated database for storing client variables." but it doesn't say why. I would think that if i have a dedicated DB for a certain app that I would want to store the client variables for that app in the same DB. thoughts? BJ ___ Sent by ePrompter, the premier email notification software. Free download at http://www.ePrompter.com. __ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Client Variable DB storage
You can specify the DSN for an application to use for storing client variables. Therefore, you can have multiple client databases, or a single one which encompasses all the apps on your server. Or even some combination of these two options. My personal thoughts is that keeping the Client variables separate from your application database helps avoid clutter, and is a little more intuitive. My thoughts Shawn Grover -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Tuesday, June 04, 2002 9:32 AM To: CF-Talk Subject: Client Variable DB storage On page 549 of Forta's CF 5 book he outlines how to store client vars in a DB. Step 1 reads "If you want, you can use an existing database, but we recommend hat you use a fresh, dedicated database for storing client variables." but it doesn't say why. I would think that if i have a dedicated DB for a certain app that I would want to store the client variables for that app in the same DB. thoughts? BJ ___ Sent by ePrompter, the premier email notification software. Free download at http://www.ePrompter.com. __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Client Variable DB storage
we have a separate database for storing client variables. Strangely enough called cfclient :P. We do it because it becomes a hassle creating a client variables storage for every app. There is not good or bad reasons to have one for every database, just preference. Anthony Petruzzi Webmaster 954-321-4703 [EMAIL PROTECTED] http://www.sheriff.org -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Tuesday, June 04, 2002 11:32 AM To: CF-Talk Subject: Client Variable DB storage On page 549 of Forta's CF 5 book he outlines how to store client vars in a DB. Step 1 reads "If you want, you can use an existing database, but we recommend hat you use a fresh, dedicated database for storing client variables." but it doesn't say why. I would think that if i have a dedicated DB for a certain app that I would want to store the client variables for that app in the same DB. thoughts? BJ ___ Sent by ePrompter, the premier email notification software. Free download at http://www.ePrompter.com. __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Client Variable DB storage
> On page 549 of Forta's CF 5 book he outlines how to store > client vars in a DB. > > Step 1 reads "If you want, you can use an existing database, > but we recommend hat you use a fresh, dedicated database for > storing client variables." but it doesn't say why. I would > think that if i have a dedicated DB for a certain app that > I would want to store the client variables for that app in > the same DB. There's nothing really wrong with using the same database to store Client variables along with the rest of the tables for that application, except that it limits how much you can secure the database, to some degree - you can't limit the user rights to a specific set of stored procedures, for example. If you're not doing that anyway, I don't think it makes a bit of difference. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Client Variable DB storage
On page 549 of Forta's CF 5 book he outlines how to store client vars in a DB. Step 1 reads "If you want, you can use an existing database, but we recommend hat you use a fresh, dedicated database for storing client variables." but it doesn't say why. I would think that if i have a dedicated DB for a certain app that I would want to store the client variables for that app in the same DB. thoughts? BJ ___ Sent by ePrompter, the premier email notification software. Free download at http://www.ePrompter.com. __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
