From owner-freebsd-database Mon Dec 27 6:44: 2 1999 Delivered-To: freebsd-database@freebsd.org Received: from carlton.innotts.co.uk (carlton.innotts.co.uk [212.56.32.2]) by hub.freebsd.org (Postfix) with ESMTP id B582F14F68 for ; Mon, 27 Dec 1999 06:43:55 -0800 (PST) (envelope-from robmel@nadt.org.uk) Received: from muffin.highwire.local (pool-1-p16.innotts.co.uk [212.56.33.16]) by carlton.innotts.co.uk (8.9.3/8.9.3) with ESMTP id OAA05199; Mon, 27 Dec 1999 14:43:52 GMT Received: from [172.16.17.20] (robsmac.highwire.local [172.16.17.20]) by muffin.highwire.local (8.9.3/8.9.3) with ESMTP id OAA01000; Mon, 27 Dec 1999 14:30:44 GMT (envelope-from robmel@nadt.org.uk) Mime-Version: 1.0 X-Sender: robmel@mailhost Message-Id: In-Reply-To: <199912261336.IAA66179@whizzo.transsys.com> References: <199912261336.IAA66179@whizzo.transsys.com> Date: Mon, 27 Dec 1999 14:31:02 +0000 To: "Louis A. Mamakos" From: Robin Melville Subject: Re: What database i can use? Cc: Gabor Esperon , freebsd-database@FreeBSD.ORG Content-Type: text/plain; charset="us-ascii" ; format="flowed" Sender: owner-freebsd-database@FreeBSD.ORG Precedence: bulk At 8:36 am -0500 26/12/99, Louis A. Mamakos wrote: > > >I need a good database server in my network, under > > >FreeBSD 3.3 > > > > > >What is recommended: Oracle, MySQL, PostgreSQL or > > >another? > > > > Previous responses by others are reasonable, although MySQL is better > > than Berend de Boer said for quick and effective apps using many > > accesses - few (and not too complex) updates. > >I'm using MySQL for a couple of applications on my FreeBSD home >automation system [...] the transactions are generally pretty simple >with lots of inserts [...] Yes, sorry, I should have been more explicit... MySQL is very fast, but less good where you have many multi-user updates, particularly across multiple tables. It has only one write thread, although many read threads. Also, because it lacks row-level locking & transaction/rollback it's necessary to use table level write locks to achieve atomic write consistency unless you can absolutely guarantee cooperative application-level access control (ie. you never use the general MySQL client or non-cooperative applications to update/insert while running multiuser). Regards Robin. ---------------------------------------------------------------------- Robin Melville, Addiction Information Service Nottingham Alcohol & Drug Team Tel: +44 (0)115 952 9478 Fax: +44 (0)115 952 9421 work: robmel@nadt.org.uk Pages: http://www.nadt.org.uk/ ---------------------------------------------------------------------- To Unsubscribe: send mail to majordomo@FreeBSD.org with "unsubscribe freebsd-database" in the body of the message