Skip to content

Misha Beshkin

my skills and thoughts

  • About everything
  • English
    • English
    • Русский

Tag: limit

MySQL total number of rows with LIMIT

In order to show paging of our resources, we use LIMIT in our MySQL query. I met some scalability issues, while using the simplest way of getting total number of rows. The simplest way to get total number of rows in you MySQL query is to run the following construction: $query = mysql_query(“SELECT COUNT(*) FROM… Continue reading MySQL total number of rows with LIMIT

Published July 12, 2011
Categorized as Issues and resolutions Tagged limit, mysql, php
Misha Beshkin
Proudly powered by WordPress.