Re: Can PostGreSQL handle 100 user database - more info

I am not sure what an ole db provider is? This must be another method of
talking to the server from a client application. What advantages does it have?

I have the open source ODBC client (and I know a Java version exists), it seems
ok but I don't know if it handles things like transactions and other advanced
functions.

It would obviously be important to have a good method of talking to P-sql from
Windows since a lot of people will want to do this.

I have only just started looking at this but if I find any limitations I'm sure
I will post them!!!

Martin

"Adam Lang" <aalang(at)rutgersinsurance(dot)com> on 30/11/2000 16:54:16

To: pgsql-general(at)postgresql(dot)org
cc: (bcc: Martin Chantler/CIMG/CVG)
Subject: Re: [GENERAL] Can PostGreSQL handle 100 user database - more info

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(dot)chantler(at)convergys(dot)com>
To: <pgsql-general(at)postgresql(dot)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.
>