| From: | Oliver Jowett <oliver(at)opencloud(dot)com> |
|---|---|
| To: | Maciek Sakrejda <msakrejda(at)truviso(dot)com> |
| Cc: | Dave Cramer <pg(at)fastcrypt(dot)com>, pgsql-jdbc(at)postgresql(dot)org |
| Subject: | Re: idea to have driver return immediately after a query |
| Date: | 2011-03-25 05:01:31 |
| Message-ID: | AANLkTikYJZk_7YK4OF1xC9k1UcVYhqf_HX22pF9at84=@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-jdbc |
On 25 March 2011 17:53, Maciek Sakrejda <msakrejda(at)truviso(dot)com> wrote:
>> For queries in a transaction, it might make sense to implement this
>> via portals, much as done for fetchsize (i.e. always ask for only 1
>> row initially...
>
> For what it's worth, you don't even need to ask for 1 row. At Truviso,
> we have a layer on top of the driver that asks for 0 rows initially,
> and this works fine (in terms of providing query metadata). There
> *may* be some plans with significant startup overhead where the cost
> of returning zero rows is much less than that of returning one row.
Asking for zero rows from a portal means "give me all the data", though.
Oliver
| From | Date | Subject | |
|---|---|---|---|
| Next Message | TereschenkoVA | 2011-03-25 06:24:25 | |
| Previous Message | Maciek Sakrejda | 2011-03-25 04:53:27 | Re: idea to have driver return immediately after a query |