Re: function call

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(dot)klaver(at)aklaver(dot)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(dot)klaver(at)aklaver(dot)com
>