Hey there,
breaking up your databases probably wouldn't be the best plan unless they
are HUGE. I have heard of org's breaking up by geographical regions, say
three main sections for the US. But this would be reall only good for your
web server responce times. As far as speed goes I would personally put the
whole thing on a centralized server that is beefed up with lots of ram and
processor power. Witht his kind of setup you will want a strong backup
solution and RAID implementation of some kind.
Instead of views try running SP's and work on limiting the info your going
after. Of course you never want a SELECT * on anything when working with a
large DB.
-----Original Message-----
From: Lincoln Manning [mailto:[EMAIL PROTECTED]]
Sent: Friday, January 12, 2001 11:48 AM
To: CF-Server
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
