Can PostGreSQL handle 100 user database - more info

From: martin(dot)chantler(at)convergys(dot)com
To: pgsql-general(at)postgresql(dot)org
Subject: Can PostGreSQL handle 100 user database - more info
Date: 2000-11-30 16:03:41
Message-ID: 852569A7.005851E6.00@notes.cbis.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Thanks for responding,

I suppose what I was really asking is if PostGreSQL works 'as good' as
other databases like Oracle. The rumour I heard implied that I would have
problems trying to run PostGreSQL with a lot of clients

As for the queries:
I have a 6000 record customer file and a bigger file containing orders
The VB programs randomly retrieved records with a like clause on the first
letter of the customer name
E.G. B%, F%, Z%. This SQL also had a join to the order file and returned a few
hundered records at a time
The slow SQL I entered simply returned the MAX value for a column in the order
file. This did seem to lock things
down, perhaps p-sql was just being cautious or maybe it just slowed everything
down quite a lot?

Thanks a lot,

M Chantler

--
NOTICE: The information contained in this electronic mail transmission is
intended by Convergys Corporation for the use of the named individual or entity
to which it is directed and may contain information that is privileged or
otherwise confidential. If you have received this electronic mail transmission
in error, please delete it from your system without copying or forwarding it,
and notify the sender of the error by reply email or by telephone (collect), so
that the sender's address records can be corrected.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Hans-Jürgen Schönig 2000-11-30 16:17:38 Re: Can PostGreSQL handle 100 user database - more info
Previous Message Gordan Bobic 2000-11-30 16:02:42 Re: Database cluster?