Re: idea to have driver return immediately after a query
| От | Maciek Sakrejda |
|---|---|
| Тема | Re: idea to have driver return immediately after a query |
| Дата | |
| Msg-id | AANLkTimkD4aRjfM-WNrnkmHMKWuXeguARP0hHWNfwxnh@mail.gmail.com обсуждение исходный текст |
| Ответ на | Re: idea to have driver return immediately after a query (Oliver Jowett <oliver@opencloud.com>) |
| Ответы |
Re: idea to have driver return immediately after a query
|
| Список | pgsql-jdbc |
> 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. Thanks, --- Maciek Sakrejda | System Architect | Truviso 1065 E. Hillsdale Blvd., Suite 215 Foster City, CA 94404 (650) 242-3500 Main www.truviso.com
В списке pgsql-jdbc по дате отправления: