cocoon-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Torsten Curdt <tcu...@dff.st>
Subject Re: esql:row-count and rowCount()
Date Sat, 23 Nov 2002 14:38:38 GMT
On Sat, 2002-11-23 at 04:51, Geoff Howard wrote:
> I've been looking into esql:row-count (just calls
> EsqlQuery.rowCount()) which is throwing a "not yet
> implemented" exception for all cases but
> EsqlConnection.LIMIT_METHOD_JDBC.  Obviously this was
> meant to be a temporary measure while some issue was
> resolved.  

Hm... actually it's slightly different...

There are two different problem that EsqlQuery needs to
solve.

1. we want only a limited window of the overall result rows
2. we want the number of the overall results

Always using the JDBC method for (2) is possible but the current
METHOD_JDBC implementation is far from being the best
solution. It's on my TODO list to rewrite that part.

Depending on the driver the resultset might be transfered from the
database to cocoon *TWICE* because of the current approach. Which
is really really bad - especially for big resultsets!

The only way around this is to execute the statement itself plus
an additional count statement.

I already have some code. You now scratched that itch again;)
I'll try to look into it within the next week.
--
Torsten


---------------------------------------------------------------------
To unsubscribe, e-mail: cocoon-dev-unsubscribe@xml.apache.org
For additional commands, email: cocoon-dev-help@xml.apache.org


Mime
View raw message