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
|
| Список | 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
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:So it would seem that the issue is with ERP application returning the information.It's not ODBC, I've just tested with simple C# through the same odbc
source and the function takes 4 seconds as well.
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?
В списке pgsql-sql по дате отправления: