Muhammed Imran Hussain

LAMP/LEMP, MEAN, JAVA Developer

Home » MySQL

SQL: Faster way to COUNT records from large data set

For small data set COUNT() function works fine but for large data set for example 1M records the query may exceed time limit. Since MySQL >= 4.0.0 we can use SQL_CALC_FOUND_ROWS option and FOUND_ROWS() function. SQL_CALC_FOUND_ROWS tells MySQL…

Read More »