| From: | Marcin Krawczyk <jankes(dot)mk(at)gmail(dot)com> |
|---|---|
| To: | Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com> |
| Cc: | "pgsql-sql(at)postgresql(dot)org" <pgsql-sql(at)postgresql(dot)org> |
| Subject: | Re: function call |
| Date: | 2014-08-06 07:41:04 |
| Message-ID: | CABnqL30b-cZUJE69QJw0kueiwJ=uBPOLDnbgRWz7hrwo-=Frfw@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-sql |
It's not ODBC, I've just tested with simple C# through the same odbc source
and the function takes 4 seconds as well.
regards
mk
2014-08-05 15:01 GMT+02:00 Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>:
> On 08/05/2014 04:28 AM, Marcin Krawczyk wrote:
>
>> Hi list,
>>
>> I have a SET returning function (defined as RETURNS TABLE), it takes 2
>> parameters and always returns one row with 3 columns. Now when I run it
>> from pgAdmin it takes around 5 seconds but when I run it from the
>> application its around 3 minutes (same parameters of course). It shows
>> up in the postgres' status server and odbc log right away so I believe
>> the applications has nothing to do with it. Where should I start looking ?
>>
>
> Just had another thought.
>
> I found in the past that ODBC logging can slow things down considerably.
>
> What happens if you turn off the ODBC logging?
>
>
>
>
>> I'm running postgres 9.1
>>
>>
>> regards
>> mk
>>
>
>
> --
> Adrian Klaver
> adrian(dot)klaver(at)aklaver(dot)com
>
| From | Date | Subject | |
|---|---|---|---|
| Next Message | John L. Poole | 2014-08-06 12:03:53 | Re: function call |
| Previous Message | Marcin Krawczyk | 2014-08-06 07:05:20 | Re: function call |