Re: PsqlODBC slow on UNION queries

Поиск
Список
Период
Сортировка
От Ludek Finstrle
Тема Re: PsqlODBC slow on UNION queries
Дата
Msg-id 20060111083256.GA10431@soptik.pzkagis.cz
обсуждение исходный текст
Ответ на Re: PsqlODBC slow on UNION queries  (Zoltan Boszormenyi <zboszor@dunaweb.hu>)
Ответы Re: PsqlODBC slow on UNION queries  (Zoltan Boszormenyi <zboszor@dunaweb.hu>)
Список 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 по дате отправления:

Предыдущее
От: Zoltan Boszormenyi
Дата:
Сообщение: Re: PsqlODBC slow on UNION queries
Следующее
От: "A.J. Langereis"
Дата:
Сообщение: Re: Values in the select