Welcome Guest, Not a member yet? Register   Sign In
DB Class : Active Records w/ SQL_CALC_FOUND_ROWS
#1

[eluser]louis w[/eluser]
Is there any plans to support the SQL_CALC_FOUND_ROWS feature with active records to be able to easily calculate the total amount of rows available when using a LIMIT?

Database library includes a count_all_results method but this is problematic when your query contains joined tables. Using the native SQL_CALC_FOUND_ROWS along with a second SELECT FOUND_ROWS() would be a low overhead way of doing this.

INFORMATION:
http://www.arraystudio.com/as-workshop/m...limit.html

Thanks.




Theme © iAndrew 2016 - Forum software by © MyBB