| Database Num_rows()? |
If you are using MySQL and not limited by a query builder. MySQL has SQL_CALC_FOUND_ROWS which will calculate the total number of results within the same query used to fetch the result set.
https://coderwall.com/p/n3b0iw/mysql-sql...erformance |
| Messages In This Thread |
|
Database Num_rows()? - by stlake2011 - 03-02-2020, 11:15 AM
RE: Database Num_rows()? - by tweenietomatoes - 03-02-2020, 12:48 PM
RE: Database Num_rows()? - by abatrans - 03-02-2020, 01:04 PM
RE: Database Num_rows()? - by InsiteFX - 03-02-2020, 02:18 PM
RE: Database Num_rows()? - by stlake2011 - 03-02-2020, 03:21 PM
RE: Database Num_rows()? - by tweenietomatoes - 03-02-2020, 03:38 PM
RE: Database Num_rows()? - by stlake2011 - 03-02-2020, 04:09 PM
RE: Database Num_rows()? - by kilishan - 03-02-2020, 09:23 PM
RE: Database Num_rows()? - by sneakyimp - 12-28-2020, 04:32 PM
RE: Database Num_rows()? - by nonebeliever - 03-03-2020, 02:55 AM
RE: Database Num_rows()? - by lukmim - 07-20-2021, 12:49 AM
RE: Database Num_rows()? - by ojmichael - 12-29-2020, 04:45 PM
|
