On 9/23/07, Rick Faircloth <[EMAIL PROTECTED]> wrote: > Now for the support people to tell me that I can have only one database > and that the "unlimited" part refers to the "type of connections" doesn't > make any sense to me. If that were the case, then why are > "Datasources/DSN's" (which I would think would refer to databases) be > listed separately from "Database Connections"? And, at least in a query, > a "datasource" is typically a database for me.
The "unlimited" data sources - in the CF Admin - can all refer to a single database. The "unlimited" database connections (again, in the CF Admin) just means they don't cap concurrent connections between CF and MySQL arbitrarily. You can ensure that different data sources using different credentials only have access to their own tables (within the single database) but, frankly, that's a lot of work for very little benefit in my opinion. I run multiple databases on my localhost setup to avoid name conflicts so I would definitely find it very restrictive to host multiple sites on a single database! Again, I'd lean toward the VPS in this case. -- Sean A Corfield -- (904) 302-SEAN An Architect's View -- http://corfield.org/ "If you're not annoying somebody, you're not really alive." -- Margaret Atwood ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| ColdFusion is delivering applications solutions at at top companies around the world in government. Find out how and where now http://www.adobe.com/cfusion/showcase/index.cfm?event=finder&productID=1522&loc=en_us Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:289268 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
