From owner-freebsd-questions Mon May 15 22:30: 6 2000 Delivered-To: freebsd-questions@freebsd.org Received: from lvdi.net (Mta.lvdi.net [216.24.138.2]) by hub.freebsd.org (Postfix) with SMTP id 8C49937BA3F for ; Mon, 15 May 2000 22:30:02 -0700 (PDT) (envelope-from notme@lvdi.net) Received: from lvdi.net ([216.24.141.40]) by lvdi.net ; Mon, 15 May 2000 22:14:35 2000 PDT Message-ID: <3920DEBF.F7AEC68E@lvdi.net> Date: Mon, 15 May 2000 22:38:07 -0700 From: Frankie Li X-Mailer: Mozilla 4.72 [en] (Win98; I) X-Accept-Language: en,pdf MIME-Version: 1.0 To: "freebsd-questions@freebsd.org" Subject: Setup for SQL Servers Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit Sender: owner-freebsd-questions@FreeBSD.ORG Precedence: bulk X-Loop: FreeBSD.ORG Hi, I am planning to build a system with Apache and SQL so that the three people of my office can run the database off the server from their machine. (We are currently connected at 10base-T, 3 machines total, no connection to the internet) I am wondering what kind of server setup would be adequate such that the search time for the an item from the database is reasonable. (i.e., from 5-10 seconds) The database is around 100 MB, and I anticipate it to grow at a stead. All of the machines in the office are Celeron 400s with 64 MB of RAM, 10base-t connection. Each machine has a printer of its own. Services I need mostly is just local printing, invoice editing, and add/remove from database new and old records of inventory. My plan was basically work everything off a browser. Of course some Cgi will be used. :) Is this setup actually feasible? The server need not to run anything else except for Apache, SQL, some small perl script or PHP. What kind of hardware would I need? (i.e., how much RAM, processor speed... ) I will only have at most 4 people connected to the server at a time... so... Thank you very much for you advice! Frankie To Unsubscribe: send mail to majordomo@FreeBSD.org with "unsubscribe freebsd-questions" in the body of the message