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: [EMAIL PROTECTED] For additional commands, email: [EMAIL PROTECTED]
