At 11:56 AM 09/05/2001 -0700, you wrote:
>I have a client who's new site will have a 20,000 record song catalog.
One of the sites I work on has a song search catalog that is twice that
size. ( www.karaokewh.com )
I think the db is SQL Server 2000, however we have never had any problems
searching against it. ( click the song search link from the left
navigation bar )
>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.
I think it all comes down to your data structure and the queries. You
should be fine on a shared SQL Server as long as that server is not
overloaded already, and as long as you develop smart.
--
Jeffry Houser | mailto:[EMAIL PROTECTED]
AIM: Reboog711 | ICQ: 5246969 | Fax / Phone: 860-223-7946
--
I'm looking for a room-mate in the Hartford CT area, starting in September
--
http://www.instantcoldfusion.com | My Book: Instant ColdFusion 5.0
--
My Band: Far Cry Fly, Alternative Folk Rock
http://www.farcryfly.com | http://www.mp3.com/FarCryFly
--
My company: DotComIt, LLC
database driven web data using ColdFusion
--
I tried all my tricks, I tried to steal a kiss...
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.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
