From owner-freebsd-questions@FreeBSD.ORG Thu Jan 17 15:20:34 2008 Return-Path: Delivered-To: freebsd-questions@freebsd.org Received: from mx1.freebsd.org (mx1.freebsd.org [IPv6:2001:4f8:fff6::34]) by hub.freebsd.org (Postfix) with ESMTP id 8E48016A418 for ; Thu, 17 Jan 2008 15:20:34 +0000 (UTC) (envelope-from darryl@osborne-ind.com) Received: from ws2.cnweb.com (ws2.cnweb.com [69.50.194.62]) by mx1.freebsd.org (Postfix) with ESMTP id 6CC2E13C4D9 for ; Thu, 17 Jan 2008 15:20:34 +0000 (UTC) (envelope-from darryl@osborne-ind.com) Received: (qmail 28822 invoked from network); 17 Jan 2008 09:20:28 -0600 Received: from p245n23.ruraltel.net (HELO Europa) (24.225.23.245) by ws2.cnweb.com with SMTP; 17 Jan 2008 09:20:28 -0600 From: "Darryl Hoar" To: "'Jim Stapleton'" , In-Reply-To: <80f4f2b20801170712g67cb5028wfda685ab118acb78@mail.gmail.com> Date: Thu, 17 Jan 2008 09:19:29 -0600 Message-ID: MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit X-Priority: 3 (Normal) X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook CWS, Build 9.0.2416 (9.0.2911.0) X-MimeOLE: Produced By Microsoft MimeOLE V6.0.6000.16545 Importance: Normal Cc: Subject: RE: CPu Questions X-BeenThere: freebsd-questions@freebsd.org X-Mailman-Version: 2.1.5 Precedence: list Reply-To: darryl@osborne-ind.com List-Id: User questions List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Thu, 17 Jan 2008 15:20:34 -0000 > In a smaller environment (50 users) will processor selection make > any real difference ? Website with some simple php scripting and > mysql databases tied in . -->> Network: 100Mb switched soon to be GB switched. -> Disk: How much information are you pulling off of the disk? If you are doing complex queries on a 1GByte table, and server multi-megabyte files, and using an ATA66 drive without a RAID setup, that disk is probably going to be a slowdown for your system, and running 4x Quad Core Xeons (core-based, not netburst) overclocked to 5Ghz won't be noticably faster than a single Pentium 4 and 2.8Ghz. (OK, that might be a slight exaggeration). Memory is helpful in this case. Memory can help here too. -->> Disk: Databases will be text lookup (think customer records, and a bug tracker). sorting records will possibly be on multiple keys. Data insertion will be VERY low volume. -> CPU: How much is there in the way of calculations? Are the queries simple or complex? Are there a lot of loops (even a "simple" program with a lot of loops or recursion can be very CPU intensive)? -->>CPU: Don't expect queries to be super complex. Every once in a while there might be a more complex query, but meat and potatoes will be simple. Does that help answer your question? -->> partially -Jim Stapleton --Darryl -- No virus found in this incoming message. Checked by AVG Free Edition. Version: 7.5.516 / Virus Database: 269.19.6/1229 - Release Date: 1/17/2008 11:12 AM