Postgres Pro
Downloads
Home   >   mailing lists

Re: function call - Mailing list pgsql-sql

From Marcin Krawczyk
Subject Re: function call
Date
Msg-id CABnqL33m+KqSYqMW=YCHWSt3213CXoaS-8=tbkGuk=JibURd4w@mail.gmail.com
Whole thread Raw
In response to Re: function call  (Adrian Klaver <adrian.klaver@aklaver.com>)
Responses Re: function call
List pgsql-sql
Tree view
I've managed to determine that there's a trigger dependency tree that slows things down. When I DISABLE one of them the function takes under 30 seconds, still more than from pgAdmin but much quicker than before.

regards
mk


2014-08-06 15:58 GMT+02:00 Adrian Klaver <adrian.klaver@aklaver.com>:
On 08/06/2014 12:41 AM, Marcin Krawczyk wrote:
It's not ODBC, I've just tested with simple C# through the same odbc
source and the function takes 4 seconds as well.

So it would seem that the issue is with ERP application returning the information.

This probably hinges on what you are defining as returning?

In your function description you note that the function issues documents.

Is that what you are using to determine that the function has completed?

If so, do you return the documents in the pgAdmin case as well?

If not, how are measuring success(returning) in the application case?




regards
mk



--
Adrian Klaver
adrian.klaver@aklaver.com

pgsql-sql by date:

Previous
From: David G Johnston
Date:
Subject: Re: Update Returning as subquery
Next
From: Marcin Krawczyk
Date:
Subject: Re: function call