> 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