Re: Application bottlenecks - Mailing list pgsql-odbc

From Hasns-Juergen Schoenig
Subject Re: Application bottlenecks
Date
Msg-id 715FC5E7-2CEE-4C13-80F2-7FAB9FEA50D7@cybertec.at
Whole thread Raw
In response to Application bottlenecks  (Carlos Henrique Reimer <carlosreimer@yahoo.com.br>)
List pgsql-odbc
Reimer,

Did you use Windows XP or Windows 2000?

    Best regards,

        Hans


Am 07.09.2005 um 13:24 schrieb Carlos Henrique Reimer:

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!

pgsql-odbc by date:

Previous
From: "Merlin Moncure"
Date:
Subject: Re: Application bottlenecks
Next
From: "Merlin Moncure"
Date:
Subject: Re: Application bottlenecks