Re: Can PostGreSQL handle 100 user database - more info
От | Adam Lang |
---|---|
Тема | Re: Can PostGreSQL handle 100 user database - more info |
Дата | |
Msg-id | 01d301c05b12$b3b81ae0$330a0a0a@6014cwpza006 обсуждение исходный текст |
Ответ на | Re: Can PostGreSQL handle 100 user database - more info (martin.chantler@convergys.com) |
Список | pgsql-general |
But there is an OLE DB provider for ODBC, so you can use ADO with an ODBC; just not as nice. As for the multiple connections thing, I do not know anything about that. Adam Lang Systems Engineer Rutgers Casualty Insurance Company http://www.rutgersinsurance.com ----- Original Message ----- From: "Elmar Haneke" <elmar@haneke.de> To: <pgsql-general@postgresql.org> Sent: Thursday, November 30, 2000 1:59 PM Subject: Re: [GENERAL] Can PostGreSQL handle 100 user database - more info > > > martin.chantler@convergys.com wrote: > > > > 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? > > > If you intend to use ADO you need an OLE-DB provider. > > > 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. > > > The ODBC midht cause some "interesting" trouble since VisualBasic > tends to open multiple connections to the Server. This has tow > disadvantages: > > 1. While using transaction isolation (not reading uncommitted data) > you cannot read the data written on one connection over another one. > If this does happen you might not immediately notive the rubbish > happening. > > 2. With 100 users it might significant if there are 500 simultaneous > connections open. At leas you have to raise the connection-limit. > > Elmar
В списке pgsql-general по дате отправления: