Re: Application bottlenecks

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!