Re: function call

Поиск
Список
Период
Сортировка
От Marcin Krawczyk
Тема Re: function call
Дата
Msg-id CABnqL33m+KqSYqMW=YCHWSt3213CXoaS-8=tbkGuk=JibURd4w@mail.gmail.com
обсуждение исходный текст
Ответ на Re: function call  (Adrian Klaver <adrian.klaver@aklaver.com>)
Ответы Re: function call  (Adrian Klaver <adrian.klaver@aklaver.com>)
Список pgsql-sql
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 по дате отправления:

Предыдущее
От: David G Johnston
Дата:
Сообщение: Re: Update Returning as subquery
Следующее
От: Marcin Krawczyk
Дата:
Сообщение: Re: function call