Re: PsqlODBC slow on UNION queries - Mailing list pgsql-odbc

From Ludek Finstrle
Subject Re: PsqlODBC slow on UNION queries
Date
Msg-id 20060111083256.GA10431@soptik.pzkagis.cz
Whole thread Raw
In response to Re: PsqlODBC slow on UNION queries  (Zoltan Boszormenyi <zboszor@dunaweb.hu>)
Responses Re: PsqlODBC slow on UNION queries  (Zoltan Boszormenyi <zboszor@dunaweb.hu>)
List pgsql-odbc
> >I forgot. Feel free to send the mylog output here to list. We can
> >help you to decode it ;-)
>
> I will, when I am back to my workplace.
>
> In the meantime, I have set MyLog on in WinXP under VMWare here,
> but Access produced some 120+ MB log and it wasn't even finished
> reading the records... I didn't feel like I have to send it to the list. ;-)
> Anyway, it turned out it used DECLARE CURSOR and it fetched
> 100 records at a time.

Ufff. What tons of records do you get? BTW could you compile psqlODBC
from source code? It is possible to disable mylog output in function
CC_mapping (it's per record mylog for problems with encoding). I think
you don't have such a problem so there is no problem to comment out
mylog(...) calls from CC_mapping. This results in much smaller mylog
output.

Regards,

Luf

pgsql-odbc by date:

Previous
From: Zoltan Boszormenyi
Date:
Subject: Re: PsqlODBC slow on UNION queries
Next
From: "A.J. Langereis"
Date:
Subject: Re: Values in the select