ok, thanks. let me know if I can help. Geoff
--- Torsten Curdt <[EMAIL PROTECTED]> wrote: > 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] > __________________________________________________ Do you Yahoo!? Yahoo! Mail Plus – Powerful. Affordable. Sign up now. http://mailplus.yahoo.com --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, email: [EMAIL PROTECTED]
