From: | Carlos Henrique Reimer <carlosreimer(at)yahoo(dot)com(dot)br> |
---|---|
To: | pgsql-odbc(at)postgresql(dot)org |
Subject: | Application bottlenecks |
Date: | 2005-09-07 11:24:16 |
Message-ID: | 20050907112416.98558.qmail@web53210.mail.yahoo.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-odbc |
Hello,
We are using Cobol Microfocus and pgsqlODBC to access Postgresql.
Originally these applications only accessed Oracle databases without ODBC, only Procobol and now we´re migrating to Postgresql and ODBC. The application logic doesn´t changed, but some applications have higher response times than the Oracle version. We worked on database tunning but even so, the response times are very different.
I turned on logging sql statemants in the server (log_duration) and discovered that the sum of all SQL duration times gives only 30% of the total response time felt at the client. This gives me a suspect that the bottleneck is outside the server.
Am I in the right way?
How can I discover the SQL duration times at the client? Is there some tool I could use?
Thanks in advance!
Reimer
---------------------------------
Yahoo! Messenger com voz: PROMOÇÃO VOCÊ PODE LEVAR UMA VIAGEM NA CONVERSA. Participe!
From | Date | Subject | |
---|---|---|---|
Next Message | Scot Loach | 2005-09-07 12:09:33 | Re: changed behavior in libpq odbc driver |
Previous Message | Dave Page | 2005-09-07 08:38:06 | Re: notice handler in libpq-based driver |