Hi, Jason,
On Thu, 23 Sep 2004 12:53:25 -0400
"Jason Coene" <jcoene@gotfrag.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@logi-track.com | www.logi-track.com