I run a small search engine on CF and MSSQL server. Runs fast as hell. Just need to know how to write good storedprocedures for performance. Like anything, if you don't optimize it for speed, it will run dog slow.
Anthony Petruzzi Webmaster 954-321-4703 http://www.sheriff.org -----Original Message----- From: Bud [mailto:[EMAIL PROTECTED]] Sent: Tuesday, March 26, 2002 7:04 PM To: CF-Talk Subject: RE: SQL lisence headaches On 3/26/02, Ian Lurie penned: >Any opinions out there on running SQL on a single proc machine? Is it worth >it? I've got a site that'll likely get 40,000+ visits in 1-2 months... I've got 2000 running on a single PIII 833 MZ processor with 512 MB RAM. About 15 databases thus far, doing probably twice that many visitors in a month for the sites using those databases. No problems. -- Bud Schneehagen - Tropical Web Creations _/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/ ColdFusion Solutions / eCommerce Development [EMAIL PROTECTED] http://www.twcreations.com/ 954.721.3452 ______________________________________________________________________ Get the mailserver that powers this list at http://www.coolfusion.com 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

