If you've onlyu got 500,000 recs between the three the machine you have
should suffice unless you are running all sorts of other stuff on it. we
have a machine here that is a P500 but we are running it as a file server,
mail server, web server, and SQL server.
The main cause of the speed could well be down to the code you use to
interogate it. Use SP's where possible. Stay away from Cursors, and
generally ensure code is efficient as poss
-----Original Message-----
From: Alex [mailto:[EMAIL PROTECTED]]
Sent: 08 June 2001 15:38
To: CF-Talk
Subject: Re: [Speeding Up SQL Server]
Are you sure its the machine? Or is it the network, or the code, or the DB
design
"Ben Densmore" <[EMAIL PROTECTED]> wrote:
I was wondering if someone can give me some ideas of the best way to speed
up
SQL Server? Right now our server that runs SQL Server is not the fastest of
machines, actually it's quite slow. it's a P 200 with 128 megs of ram. I've
been bugging the company to buy a new server which they did but now they
want
to use that server for something else. Anyway, now they want to try and find
ways to speed it up without upgrading the hardware. We have 3 DB's running
with a total of probably 500,000 records between the 3.
Thanks for any help.
Ben
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
