Re: Application bottlenecks

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!