cocoon-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Geoff Howard <cocoonge...@yahoo.com>
Subject Re: esql:row-count and rowCount()
Date Sun, 24 Nov 2002 12:29:13 GMT
ok, thanks.  let me know if I can help.

Geoff

--- Torsten Curdt <tcurdt@dff.st> 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:
> cocoon-dev-unsubscribe@xml.apache.org
> For additional commands, email:
> cocoon-dev-help@xml.apache.org
> 


__________________________________________________
Do you Yahoo!?
Yahoo! Mail Plus  Powerful. Affordable. Sign up now.
http://mailplus.yahoo.com

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


Mime
View raw message