Date: Fri, 21 Nov 1997 18:22:25 +0000 From: Robin Melville <robmel@nadt.org.uk> To: Andreas Klemm <andreas@klemm.gtn.com> Cc: freebsd-isp@FreeBSD.ORG Subject: Re: PostgreSQL for Yellow Pages implementation Message-ID: <3.0.5.32.19971121182225.007db8d0@wrcmail> In-Reply-To: <19971110181136.45756@klemm.gtn.com> References: <Pine.BSF.3.91.971110120853.3976F-100000@pappquds.papp.undp.org> <199711071458.JAA15692@doleh.com> <Pine.BSF.3.91.971110120853.3976F-100000@pappquds.papp.undp.org>
next in thread | previous in thread | raw e-mail | index | archive | help
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/ ---------------------------------------------------------
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?3.0.5.32.19971121182225.007db8d0>