From: | Ludek Finstrle <luf(at)pzkagis(dot)cz> |
---|---|
To: | Zoltan Boszormenyi <zboszor(at)dunaweb(dot)hu> |
Cc: | Ludek Finstrle <luf(at)pzkagis(dot)cz>, pgsql-odbc(at)postgresql(dot)org |
Subject: | Re: PsqlODBC slow on UNION queries |
Date: | 2006-01-27 17:13:02 |
Message-ID: | 20060127171302.GA20396@soptik.pzkagis.cz |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-odbc |
> >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 <case size> (<case size> = 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
From | Date | Subject | |
---|---|---|---|
Next Message | Zoltan Boszormenyi | 2006-01-27 17:31:58 | Re: PsqlODBC slow on UNION queries |
Previous Message | Gladston Bom Conselho | 2006-01-27 16:21:59 | unsubscribe |