> In reality would you not tend to only need to read the > user data at > login time and then cache whatever user data is required > (in a > persistant scope of some type) so that your example would > become
Not necessarily... if there is an administrative tool to manage users, it might need to cross-reference some other data, or particularly if the application needs to generate reports based on users (which might include the user's name or simply an aggregated number of users in a particular area at a particular time), then the database would need to reference both the user database and the alternate database. I'm not personally aware of any significant performance issues involved with doing things this way either with mssql, oracle or any other database. I would be surprised if there are any (unless you're talking about using a table from a physically separate linked server in another room or half-way around the world in which case you'll have attenuation/lag issues). The only issue I might expect from this is regarding migration and/or replication -- if you ever need to migrate your database to another machine, etc. you then have to move the user database first before moving any other databases, and if there are constraints between databases they may need to be dropped before migrating. s. isaac dealey 954.927.5117 new epoch : isn't it time for a change? add features without fixtures with the onTap open source framework http://www.sys-con.com/story/?storyid=44477&DE=1 http://www.sys-con.com/story/?storyid=45569&DE=1 http://www.fusiontap.com ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:184877 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=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
