I am a part of the speed team at a fast growing internet startup. Our team is basically focused on speeding up user access to our system. We are able to handle our current load, but we would like to develop a speed growth plan. My specific questions are..
1. We have hundreds of car dealerships across the country that use our system based around a few large databases. What would be the benefit of creating a database for each dealership? Basically splitting everything into separate databases. Is this a management headache waiting to happen or would the smaller databases and speed gains be worth it?
2. I know of a few large CF based companies that use large table views instead of joins for frequently requested information to get information to customers quickly. Has anyone tried this and what are the implications? Is there any software to automate this strategy?
3. Finally, I have been using SQL Profiler to track locking queries, and a few tables and few queries seem to be the most common. Are there any straight forward remedies. I have been using the (No Lock) option when I can. Are there other ways to minimize this?
By the way, we are using SQLServer 7.
Lincoln Manning AVV lincoln@avv.com Ph. 614-340-5139 Fax 614-487-1955 http://www.avv.com/
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm ------------------------------------------------------------------------------ To unsubscribe, send a message to cf-server-request@houseoffusion.com with 'unsubscribe' in the body or visit the list page at www.houseoffusion.com
CF-Server
Lincoln Manning