Skip site navigation (1) Skip section navigation (2)

Re: Application bottlenecks

From: "Merlin Moncure" <merlin(dot)moncure(at)rcsonline(dot)com>
To: "Carlos Henrique Reimer" <carlosreimer(at)yahoo(dot)com(dot)br>
Cc: <pgsql-odbc(at)postgresql(dot)org>
Subject: Re: Application bottlenecks
Date: 2005-09-08 12:17:15
Message-ID: 6EE64EF3AB31D5448D0007DD34EEB3417DD2A5@Herge.rcsinc.local (view raw or flat)
Thread:
Lists: pgsql-odbc
Hi Carlos, I am working on project right now you might be interested in, namely a extfh interface to postgresql and a isam wrapper for libpq.  I already have an isam bridge working direct to postgresql from AcuCobol without using odbc or a commercial driver.  I just need to convert it to extfh and do a few other things to support microfocus.

Merlin

________________________________________
From: pgsql-odbc-owner(at)postgresql(dot)org [mailto:pgsql-odbc-owner(at)postgresql(dot)org] On Behalf Of Carlos Henrique Reimer
Sent: Wednesday, September 07, 2005 7:24 AM
To: pgsql-odbc(at)postgresql(dot)org
Subject: [ODBC] 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!

Responses

pgsql-odbc by date

Next:From: Cleber NardelliDate: 2005-09-08 12:32:50
Subject: Re: Application bottlenecks
Previous:From: Dave PageDate: 2005-09-08 10:26:08
Subject: Re: Continuing encoding fun....

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group