20K is small. We have one SQL Server (2k) with about 10 extranet apps on
it. One of our apps in particular is associated with hundreds of
thousands of records (about 500,000) - That's still small. I think as
long as you have done proper maintenance (indexing, relational, etc.)
you should be fine.
Mark
-----Original Message-----
From: Brook Davies [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, September 05, 2001 2:56 PM
To: CF-Talk
Subject: SQL SERVER Usage Question
I have a client who's new site will have a 20,000 record song catalog.
The
site is search intensive. Is this a small record set? Should I consider
a
dedicated SQl Server or can I use a shared SQL server without a huge
impact
on the SQL Server usage. The SQL Server is 7,0, 1 gig of ram and a dual
550
processor with RAID 1.
Thanks for the advise, I realize the question is a little vague.....
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Your ad could be here. Monies from ads go to support these lists and provide more
resources for the community. http://www.fusionauthority.com/ads.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
