Re: Can PostGreSQL handle 100 user database - more info - Mailing list pgsql-general

From Adam Lang
Subject Re: Can PostGreSQL handle 100 user database - more info
Date
Msg-id 00fc01c05aee$2cf45420$330a0a0a@6014cwpza006
Whole thread Raw
In response to Can PostGreSQL handle 100 user database - more info  (martin.chantler@convergys.com)
List pgsql-general
One thing to consider since you mentioned VB is the lack of ole db provider.
It really puts a black mark on the DB for Windows developers.

Unfortunately only one person has volunteered to try to make one, but he is
extremely busy (as most of us are).

Part of the drawback of making one is software and knowledge needed.  You
need a good understanding of the way the database talks to the client, the
database schema and other topics.  As for the software, it seems atleast
VC++ 6.0 is best.

ODBC can be used, but again, there is faltering support for it also.

I'm not pointing fingers, just things to look out for since you are a VB
programmer.  I'd be more than willing to give the provider a try (while
asking many questions along the way), but the problem of not having VC++ is
a major obstacle.


Adam Lang
Systems Engineer
Rutgers Casualty Insurance Company
http://www.rutgersinsurance.com
----- Original Message -----
From: <martin.chantler@convergys.com>
To: <pgsql-general@postgresql.org>
Sent: Thursday, November 30, 2000 11:03 AM
Subject: [GENERAL] Can PostGreSQL handle 100 user database - more info


>
>
> 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.
>


pgsql-general by date:

Previous
From: Joe Kislo
Date:
Subject: Re: Unanswered questions about Postgre
Next
From: Hannu Krosing
Date:
Subject: Re: [HACKERS] Indexing for geographic objects?