title: Limit on page display only
body: <p>I want to ask if there would be a solution to query the MySQL database trough PHP to load only 1 page from a set of results but in the pagination to still display like [1] 2 3 4 5... So when the user clicks the page two like 1 [2] 3 4 5... then to load the second page and so on?</p>
  
  <p>My database is very huge and to load 1000 pages at once would consume a lot of bandwidth and it takes for the process about 50 seconds which is too much.</p>
  
  <p>I need to find a solution to lower the loading time. My actual query looks like :</p>
  
  <pre><code>$start = ($page - 1) * $per_page;
  $query = '
          SELECT *, (MATCH(url) AGAINST('.$qo1.''.$out.''.$qo2.' IN BOOLEAN MODE) * 0.015 + MATCH(title) AGAINST ('.$qo1.''.$out.''.$qo2.' IN BOOLEAN MODE) * 0.015 + MATCH(description,body) AGAINST('.$qo1.''.$out.''.$qo2.' IN BOOLEAN MODE) * 0.040 + MATCH(keywords) AGAINST ('.$qo1.''.$out.''.$qo2.' IN BOOLEAN MODE) * 0.030) AS relevance
          FROM table
          WHERE MATCH(url, title, description, body, keywords) AGAINST ('.$qo1.''.$out.''.$qo2.' IN BOOLEAN MODE)
          ORDER BY relevance '.$ord.' LIMIT '.$start.','.$per_page.'';
  </code></pre>
  
  <p>Regards</p>