From owner-freebsd-questions@FreeBSD.ORG  Sun Nov 16 05:25:04 2003
Return-Path: <owner-freebsd-questions@FreeBSD.ORG>
Delivered-To: freebsd-questions@freebsd.org
Received: from mx1.FreeBSD.org (mx1.freebsd.org [216.136.204.125])
	by hub.freebsd.org (Postfix) with ESMTP id 1DBAC16A4CE
	for <freebsd-questions@freebsd.org>;
	Sun, 16 Nov 2003 05:25:04 -0800 (PST)
Received: from hotmail.com (law11-oe32.law11.hotmail.com [64.4.16.89])
	by mx1.FreeBSD.org (Postfix) with ESMTP id 6EEE543F85
	for <freebsd-questions@freebsd.org>;
	Sun, 16 Nov 2003 05:25:03 -0800 (PST)
	(envelope-from weiwuzhang@hotmail.com)
Received: from mail pickup service by hotmail.com with Microsoft SMTPSVC;
	 Sun, 16 Nov 2003 05:25:03 -0800
Received: from 218.193.5.120 by law11-oe32.law11.hotmail.com with DAV;
	Sun, 16 Nov 2003 13:25:03 +0000
X-Originating-IP: [218.193.5.120]
X-Originating-Email: [weiwuzhang@hotmail.com]
Message-ID: <3FB77AC0.7040704@hotmail.com>
Date: Sun, 16 Nov 2003 21:25:20 +0800
From: Zhang Weiwu <weiwuzhang@hotmail.com>
User-Agent: Mozilla/5.0 (X11; U; FreeBSD i386; en-US; rv:1.4.1) Gecko/20031105
X-Accept-Language: en-us, en
MIME-Version: 1.0
To: freebsd-questions@freebsd.org
Content-Type: text/plain; charset=us-ascii; format=flowed
Content-Transfer-Encoding: 7bit
X-OriginalArrivalTime: 16 Nov 2003 13:25:03.0348 (UTC)
	FILETIME=[0AFB7B40:01C3AC45]
Subject: seperating SQL and application server?
X-BeenThere: freebsd-questions@freebsd.org
X-Mailman-Version: 2.1.1
Precedence: list
List-Id: User questions <freebsd-questions.freebsd.org>
List-Unsubscribe: <http://lists.freebsd.org/mailman/listinfo/freebsd-questions>,
	<mailto:freebsd-questions-request@freebsd.org?subject=unsubscribe>
List-Archive: <http://lists.freebsd.org/pipermail/freebsd-questions>
List-Post: <mailto:freebsd-questions@freebsd.org>
List-Help: <mailto:freebsd-questions-request@freebsd.org?subject=help>
List-Subscribe: <http://lists.freebsd.org/mailman/listinfo/freebsd-questions>,
	<mailto:freebsd-questions-request@freebsd.org?subject=subscribe>
X-List-Received-Date: Sun, 16 Nov 2003 13:25:04 -0000

Hello. I am running apache + php + mysql on an PIII 800MHz server. 
Phpgroupware webpages takes several seconds to show up on a LAN (15 
seconds at max). I mean each webpage takes several seconds to show up, 
even if I am the only user to access the server, and the server have no 
other works to do.

I wish to know what slowed it down. A static page is 10 times faster. I 
know phpgroupware is very complicated, and each page are displayed after 
complicated process, so is the CPU too slow? Or is it the I/O problem? 
Or should I put the SQL server on another box? What is likely to be the 
slowest part?

I have a very old Pentium 200 box (compaq deskpro, years old but very 
good quanlity), if I let it run mysql server for phpgroupware, would it 
bring up the speed or actually slow it down?