From owner-freebsd-isp Fri Nov 21 11:15:00 1997 Return-Path: Received: (from root@localhost) by hub.freebsd.org (8.8.7/8.8.7) id LAA02988 for isp-outgoing; Fri, 21 Nov 1997 11:15:00 -0800 (PST) (envelope-from owner-freebsd-isp) Received: from relay2.mail.uk.psi.net (sys1.london.uk.psi.net [154.32.108.2]) by hub.freebsd.org (8.8.7/8.8.7) with ESMTP id LAA02975 for ; Fri, 21 Nov 1997 11:14:56 -0800 (PST) (envelope-from robmel@nadt.org.uk) Received: from sys4.cambridge.uk.psi.net (sys4.cambridge.uk.psi.net [154.32.106.14]) by relay2.mail.uk.psi.net (8.8.4/) with ESMTP id TAA26822; Fri, 21 Nov 1997 19:14:52 GMT Received: by sys4.cambridge.uk.psi.net (8.8.5/SMI-5.5-UKPSINet) id TAA26662; Fri, 21 Nov 1997 19:10:14 GMT Received: from infodev.nadt.org.uk (infodev.nadt.org.uk [172.16.99.205]) by charlie.nadt.org.uk (8.8.5/8.6.12) with SMTP id SAA22161; Fri, 21 Nov 1997 18:22:25 GMT Message-Id: <3.0.5.32.19971121182225.007db8d0@wrcmail> X-Sender: robmel@wrcmail X-Mailer: QUALCOMM Windows Eudora Light Version 3.0.5 (32) Date: Fri, 21 Nov 1997 18:22:25 +0000 To: Andreas Klemm From: Robin Melville Subject: Re: PostgreSQL for Yellow Pages implementation Cc: freebsd-isp@FreeBSD.ORG In-Reply-To: <19971110181136.45756@klemm.gtn.com> References: <199711071458.JAA15692@doleh.com> Mime-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Sender: owner-freebsd-isp@FreeBSD.ORG X-Loop: FreeBSD.org Precedence: bulk At 18:11 10/11/97 +0100, you wrote: >On Mon, Nov 10, 1997 at 12:40:13PM +0200, Amjad R. Alsharif wrote: >> >> Dear Sir / Madam, >> >> Please do bear withme since I do not know the best approach to present >> you with my immediate need to implement PostgreSQL. >> >> I need to establish an Online "Yellow Pages" to serve the business >> communite within Jerusalem area so I have been looking into different databases [Andreas Klemm wrote...] >Postgresql is a really nice database ... >> 3. Do you think that PostgreSQL is the right product for such a project? > >Yes I think so. You might also think about "mysql". It rather depends how much data you are planning to handle. If small amounts, and speed is not an issue, postgresql is fine... if large then try mysql -- it has far less features but is much quicker and seems more robust. I recently stress-tested them both and discovered that 250,000 updates on postgresql took 1 hour 10 minutes, on Mysql just 9 minutes. Simple joined selects on the trial database were at least 3 times quicker on mysql than on pgress (which also ran out of memory sometimes). A further possibility is "msql" which has a tiny subset of SQL functionality but is well supported for web access. A reasonably fully featured commercial alternative which works well on FreeBSD is Yard (http://www.yard.de/). Regards Robin. -------------------------------------------------------- Robin Melville, Addiction & Forensic Information Service Nottingham Alcohol & Drug Team (Extn. 49178) Vox: +44 (0)115 952 9478 Fax: +44 (0)115 952 9421 Email: robmel@nadt.org.uk WWW: http://www.innotts.co.uk/nadt/ ---------------------------------------------------------