使用功能加速数据库查询

Question

Hello my database query very slow. 5 minutes for listing 4000 rows in html table... Please help.

         **$query = "SELECT * FROM tblRazduzeniUgovori WHERE Status='razduzen'";**
         if ($result = mysqli_query($con, $query)) {
             while($row = mysqli_fetch_array($result))
             {
               echo "<tr>";
               echo "<td><input type='checkbox' name='brojUgovora[]' value='" . $row['Broj'] . "'/></td>";

Thanks you.

Answer 1

First: add status as an index on the database table, this will speed up the select portion of the script.

Second: concatenate the string, rather than issuing an echo statement each time, echo * 4000 can be quite slow.

$query = "SELECT * FROM tblRazduzeniUgovori WHERE Status='razduzen'";
     $output = '';
     if ($result = mysqli_query($con, $query)) {
         while($row = mysqli_fetch_array($result))
         {
           $output .= "<tr>";
           $output .= "<td><input type='checkbox' name='brojUgovora[]' value='" . $row['Broj'] . "'/></td>";
         }
      }
      echo $output;