The new version has made some significant improvements in performance, but
watch out for some critical problems trying to manage a larger system.
SQL2000 Enterprise Manager can take up to 10 minutes to list 500 databases
on a 2-proc 1GHz system with 1GB of RAM and RAID5 U2W with 128MB of on-board
SCSI RAM and 10,000 RPM drives.
These little gothchas can be a annoying for the admin and often lead to
folks reporting that things are slower. TPC's are one thing, but if it takes
you 10 minutes to drop one table, you have a problem.
Good Luck,
- Steve
-----Original Message-----
From: Caulfield, Michael [mailto:[EMAIL PROTECTED]]
Sent: Friday, April 27, 2001 2:56 PM
To: CF-Talk
Subject: RE: SQL2000 server not recognized by CF 4.5
On all tests we've run over here, we've found SQL Server 2000 to be
*significantly* faster than SQL 7.0, particularly with queries where
optimization plays a larger role.
SQL Server 2000 also holds the industry record for TPC-C performance, which
is a pretty good indicator of real world performance (SQL 7 doesn't even
place). See http://www.tpc.org/tpcc/results/tpcc_perf_results.asp for more
info.
Michael Caulfield
-----Original Message-----
From: Correa, Orlando (ITSC) [mailto:[EMAIL PROTECTED]]
Sent: Friday, April 27, 2001 11:39 AM
To: CF-Talk
Subject: RE: SQL2000 server not recognized by CF 4.5
Has anyone heard if SQL2000 is actually slower than SQL 7.0?
Orlando Correa
IHS Web Team
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
