| From: | Markus Schaber <schabios(at)logi-track(dot)com> |
|---|---|
| To: | "Jason Coene" <jcoene(at)gotfrag(dot)com> |
| Cc: | "'Mr Pink'" <mr_pink_is_the_only_pro(at)yahoo(dot)com>, "'Scott Kirkwood'" <scottakirkwood(at)gmail(dot)com>, <pgsql-performance(at)postgresql(dot)org> |
| Subject: | Re: Caching of Queries |
| Date: | 2004-09-23 17:46:26 |
| Message-ID: | 20040923194626.708b7bce@kingfisher.intern.logi-track.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-performance |
Hi, Jason,
On Thu, 23 Sep 2004 12:53:25 -0400
"Jason Coene" <jcoene(at)gotfrag(dot)com> wrote:
> I've looked at PREPARE, but apparently it only lasts per-session - that's
> worthless in our case (web based service, one connection per data-requiring
> connection).
This sounds like the loads of connection init and close may be the
reason for the slowdown. Can you use connection pooling in your service?
HTH,
Markus
--
markus schaber | dipl. informatiker
logi-track ag | rennweg 14-16 | ch 8001 zürich
phone +41-43-888 62 52 | fax +41-43-888 62 53
mailto:schabios(at)logi-track(dot)com | www.logi-track.com
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Anjan Dave | 2004-09-23 18:05:05 | Re: SAN performance |
| Previous Message | Gaetano Mendola | 2004-09-23 17:40:32 | Re: Caching of Queries |