Re: PsqlODBC slow on UNION queries

> >SQLExecDirect select * from view (which fire the execution again)
> 
> ... retrieve 1000+ rows and then _I_ pressed Cancel. Can you confirm that?
> I am just curious.

Yes. I see > 1000 < 1100 rows. You could go to the bottom of mylog (I see
union one) and search backward "select * from v_invoice_browse".
Then you search forward fetch  ( = 100 in your
configuration so you search "fetch 100"). I count 11 (I hope I don't
create a mistake) "fetch 100" => > 1000 < 1100 :-)

There is SQLCancel after last "fetch 100" ;-)

> >create some repro app. Some of the questions:
> >1) could you try similar view without text (char, varchar, ...) columns?
> 
> Would the same view do but only seleting numeric (integer and decimal) 
> columns?

Yes. It's enough. I don't know if the problem isn't char column
handling.

> >4) could you say me what are the query for (it's fired bettwen two calls
> >  of select * from view):

...

> I don't know what are these. I guess  PowerBuilder tries something 
> behind everyones' back.

I think so. Could you try these selects in psql or PgAdmin tool?
I'm curios what you see.

Regards,

Luf