| From: | Peter Mount <peter(at)retep(dot)org(dot)uk> |
|---|---|
| To: | Ingo Luetkebohle <ingo(at)blank(dot)pages(dot)de>, pgsql-jdbc(at)postgresql(dot)org |
| Subject: | Re: Concurrency supported? |
| Date: | 2001-03-01 20:03:29 |
| Message-ID: | 5.0.2.1.0.20010301200149.02237070@mail.retep.org.uk |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-jdbc |
At 02:20 25/02/01 +0100, Ingo Luetkebohle wrote:
>Hiya,
>
>how good is concurrency supported in the JDBC driver? For example, if
>I have a small process with about 50 threads, some of them requesting
>large objects, will one JDBC connection suffice? If one thread is
>executing a large select which takes seconds to execute, will other
>threads be able to still get their results in time or do they have to
>wait?
They have to wait as there is only one physical network connection. To get
round this, you need to use a Connection pool.
>In general, are there concurrency limitations in the protocol
>PostgreSQL uses?
Only 1 action can occur at one time, be it an SQL query or a FastPath
command. The JDBC driver however ensures that only one Thread has ownership
of the connection at any one time.
Peter
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Peter Mount | 2001-03-01 20:04:36 | Re: PATCH to org/postgresql/jdbc2/DatabaseMetaData.java |
| Previous Message | Peter Mount | 2001-03-01 20:01:43 | Re: Java class documentation |