Date: Tue, 16 May 2000 02:29:40 -0400 From: "Thimble Smith" <tim@mysql.com> To: Frankie Li <notme@lvdi.net> Cc: freebsd-questions@FreeBSD.ORG Subject: Re: Setup for SQL Servers Message-ID: <20000516022940.B88713@threads.polyesthetic.msg> In-Reply-To: <3920DEBF.F7AEC68E@lvdi.net>; from notme@lvdi.net on Mon, May 15, 2000 at 10:38:07PM -0700 References: <3920DEBF.F7AEC68E@lvdi.net>
next in thread | previous in thread | raw e-mail | index | archive | help
On Mon, May 15, 2000 at 10:38:07PM -0700, Frankie Li wrote: > 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. > > Services I need mostly is just local printing, invoice editing, and > add/remove from database new and old records of inventory. > > Is this setup actually feasible? The server need not to run anything > else except for Apache, SQL, some small perl script or PHP. This depends on how big you expect the database to get, and what kinds of queries you'll be running against it. Probably one of the office machines would do just fine, given the low requirements you've stated. Probably 5-10 seconds is too long for queries to take, if there's a human waiting (2-3 seconds is about as long as I'd want to wait for a typical query). Once you get up to 10 seconds, you might as well have the person get up and grab some coffee, I think. 400Mhz is going to be plenty fast, I expect; you might want more than 64M of RAM, but that will do in the beginning at least. You might want to get a nice SCSI disk or two, though. Again, even that probably isn't necessary. If you've got FreeBSD set up on a machine, why don't you throw a database on there and run some tests? Get some data that is reasonably close to the real thing (maybe quadruple the data artificially, so you will know how things will scale), and then run some of your typical queries against it. My guess is that you'll be fine with a relatively low-budget machine. You might run into something surprising, though - the nice thing about using FreeBSD is you're not out any money, and you learned something on the way. There are several free database engines in the ports tree that you can try out. Good luck, Tim -- Tim Smith < tim@mysql.com > :MySQL Development Team: Boone, NC USA. To Unsubscribe: send mail to majordomo@FreeBSD.org with "unsubscribe freebsd-questions" in the body of the message
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?20000516022940.B88713>