From owner-freebsd-database Fri Jan 30 21:06:42 1998 Return-Path: Received: (from majordom@localhost) by hub.freebsd.org (8.8.8/8.8.8) id VAA14378 for database-outgoing; Fri, 30 Jan 1998 21:06:42 -0800 (PST) (envelope-from owner-freebsd-database@FreeBSD.ORG) Received: from ymris.ddm.on.ca (cisco4-200.cas.golden.net [207.6.168.200]) by hub.freebsd.org (8.8.8/8.8.8) with ESMTP id VAA14195; Fri, 30 Jan 1998 21:04:22 -0800 (PST) (envelope-from dchapes@ddm.on.ca) Received: from squigy.ddm.on.ca (squigy.ddm.on.ca [209.47.139.138]) by ymris.ddm.on.ca (8.8.8/8.8.8) with ESMTP id AAA03419; Sat, 31 Jan 1998 00:04:05 -0500 (EST) (envelope-from dchapes@ymris.ddm.on.ca) From: Dave Chapeskie Received: (from dchapes@localhost) by squigy.ddm.on.ca (8.8.8/8.8.7) id AAA03033; Sat, 31 Jan 1998 00:04:02 -0500 (EST) Message-ID: <19980131000402.29261@ddm.on.ca> Date: Sat, 31 Jan 1998 00:04:02 -0500 To: Omar Thameen Cc: freebsd-isp@FreeBSD.ORG, freebsd-database@FreeBSD.ORG Subject: Re: SQL choice questions. Reply-To: freebsd-database@FreeBSD.ORG References: <027301bd2ce2$05517f20$0f3d31cc@electron.nuc.net> <3.0.3.32.19980129140755.033893e0@infowest.com> <19980130233347.07030@clifford.inch.com> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii X-Mailer: Mutt 0.88 In-Reply-To: <19980130233347.07030@clifford.inch.com>; from Omar Thameen on Fri, Jan 30, 1998 at 11:33:47PM -0500 Sender: owner-freebsd-database@FreeBSD.ORG Precedence: bulk X-To-Unsubscribe: mail to majordomo@FreeBSD.org "unsubscribe database" [BTW, this belongs in freebsd-database, send all replies there] On Fri, Jan 30, 1998 at 11:33:47PM -0500, Omar Thameen wrote: > Check on the MySQL homepage (http://www.tcx.se) - there's a link to a > bunch of benchmarks if performance is an issue for you. FYI, we use > MySQL. It performs well and has a nice license agreement. Take those benchmarks with a huge grain of salt. They've been discussed recently on the PgSQL mailing lists (with the guy who did the benchmarks participating in the discussion). The impression I got was that his only experience with PgSQL was to get it to run the benchmarks and that he doesn't understand how the PgSQL 'vacuum' command is used in the real world. I'm also not sure how well he understands how large RDBMS systems are used. IMHO, if all you want is simple single table lookups then msql or MySQL may be fine but if you want something free that approaches a real RDBMS then go for PostgreSQL. -- Dave Chapeskie, DDM Consulting E-Mail: dchapes@ddm.on.ca