On Thu, Feb 14, 2008 at 3:30 PM, Ken Prows <[EMAIL PROTECTED]> wrote: > I am trying to find a way to use MySQL's FOUND_ROWS() feature with Rose: > > > http://dev.mysql.com/doc/refman/5.0/en/information-functions.html#function_found-rows > > I am most interested in getting this to work with my Manager classes so > that I do not have to do a second query to find the total count using > the 'get_objects_count' method.
Usually people want to do this because they're using LIMIT, but it turns out to be a bad idea. It's usually faster to do a second COUNT query than to use LIMIT and FOUND_ROWS. Since you are not using LIMIT, I don't think you need SQL_CALC_FOUND_ROWS. "In the absence of the SQL_CALC_FOUND_ROWS option in the most recent SELECT statement, FOUND_ROWS() returns the number of rows in the result set returned by that statement." Try calling FOUND_ROWS() without SQL_CALC_FOUND_ROWS and see if it works. (Kind of seems like you should be able to get this from DBI in some way too, but I think $sth->rows only works for INSERT//UPDATE/DELETE.) - Perrin ------------------------------------------------------------------------- This SF.net email is sponsored by: Microsoft Defy all challenges. Microsoft(R) Visual Studio 2008. http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/ _______________________________________________ Rose-db-object mailing list Rose-db-object@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/rose-db-object
