> straight forward remedies. I have been using the (No Lock) option when I
> can. Are there other ways to minimize this?
What do you mean you have been using the "no lock" option when you can? You
HAVE to lock all database querries or else data corruption WILL occur.
--=@ greg @=--
----- Original Message -----
From: "Lincoln Manning" <[EMAIL PROTECTED]>
To: "CF-Server" <[EMAIL PROTECTED]>
Sent: Friday, January 12, 2001 11:48 AM
Subject: Best Practices Databases
> 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
> [EMAIL PROTECTED]
> 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 [EMAIL PROTECTED] with
'unsubscribe' in the body or visit the list page at www.houseoffusion.com
