From: | "Jayesh K(dot) Parayali" <jparayali(at)TOTALFLOOD(dot)com> |
---|---|
To: | "Vicktor" <vic(at)adv(dot)ru>, "Dino Cherian" <inimss(at)yahoo(dot)com> |
Cc: | <pgsql-jdbc(at)postgresql(dot)org> |
Subject: | Re: Where should I connect to the database? |
Date: | 2001-11-23 18:02:25 |
Message-ID: | 8ACB76BF6B98C94FB6959B660C051BA50C9BAE@PACIFIC.TOTALFLOOD.COM |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-jdbc |
Performance improvement with Option 1 is nigligible if you are using
connection pooling.
Jayesh
-----Original Message-----
From: Vicktor [mailto:vic(at)adv(dot)ru]
Sent: Friday, November 23, 2001 9:51 AM
To: Dino Cherian
Cc: pgsql-jdbc(at)postgresql(dot)org
Subject: Re: [JDBC] Where should I connect to the database?
Option 1 if you want your application more fast.
Vic
On Fri, 23 Nov 2001 04:11:50 -0800 (PST)
Dino Cherian <inimss(at)yahoo(dot)com> wrote:
> Hi all,
>
> I would like to know which one is the best method of
> managing database connection in Java 1.3 (with
> PostgreSQL 7.1.2 JDBC).
>
> Option 1:
> Connect to the database in the "main" function and
> disconnect on program exit. Use it throughout the life
> of the application. "Connect once and use for ever".
>
> Option 2:
> Connect to the database near the code that uses it
> and disconnect after that block of code. "Use and
> throw away".
>
> Please help me.
>
> Thanks
> Dino
>
> __________________________________________________
> Do You Yahoo!?
> Yahoo! GeoCities - quick and easy web site hosting, just $8.95/month.
> http://geocities.yahoo.com/ps/info1
>
> ---------------------------(end of
broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster
>
---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?
From | Date | Subject | |
---|---|---|---|
Next Message | Dave Cramer | 2001-11-23 18:33:27 | Re: Where should I connect to the database? |
Previous Message | Vicktor | 2001-11-23 17:50:54 | Re: Where should I connect to the database? |