<div class="table-responsive">
<table class="table table-striped">
<thead>
<tr>
<th class="text-center">ID</th>
<th>Nome</th>
<th>Cpf</th>
<th>Estado</th>
<th>Cidade</th>
<th>Filho Data Nascimento</th>
<th>Categoria</th>
<th>Cadastro</th>
<th>Usuário</th>
<th class="text-center">Ações</th>
</tr>
</thead>
<tbody>
$mysql = new mysqli("localhost", "root", "", "dbax");
$query = $mysql->query("SELECT * FROM c_endereco INNER JOIN c_cliente ON c_cliente.idunico_cliente = c_endereco.idunico_cliente INNER JOIN c_cadastro ON c_cadastro.idunico_cliente = c_endereco.idunico_cliente INNER JOIN c_entrevista ON c_entrevista.idunico_cliente = c_endereco.idunico_cliente INNER JOIN c_finalizou ON c_finalizou.idunico_cliente = c_endereco.idunico_cliente ORDER BY c_cliente.ID DESC LIMIT 10;");
while($row = $query->fetch_array()){
$c_link = "http://localhost/painel/redireciona.php?id=".$row['idunico_cliente']."&cep=".$row['cliente_cep'];
<tr>
<td class="text-center" style="cursor: pointer;" onclick="window.open('<?php echo $c_link; ?>');"><?php echo $row['ID']; ?></td>
<td style="cursor: pointer;" onclick="window.open('<?php echo $c_link; ?>');"><?php echo $row['cliente_nome']; ?></td>
<td style="cursor: pointer;" onclick="window.open('<?php echo $c_link; ?>');"><?php echo $row['cliente_cpf']; ?></td>
<td style="cursor: pointer;" onclick="window.open('<?php echo $c_link; ?>');"><?php echo $row['cliente_estado']; ?></td>
<td style="cursor: pointer;" onclick="window.open('<?php echo $c_link; ?>');"><?php echo $row['cliente_cidade']; ?></td>
<td style="cursor: pointer;" onclick="window.open('<?php echo $c_link; ?>');"><?php echo $row['cliente_filho_nascimento']; ?></td>
<td style="cursor: pointer;" onclick="window.open('<?php echo $c_link; ?>');"><?php echo $row['cliente_categoria']; ?></td>
<td style="cursor: pointer;" onclick="window.open('<?php echo $c_link; ?>');"><?php echo $row['cliente_cadastro_data']; ?></td>
<td style="cursor: pointer;" onclick="window.open('<?php echo $c_link; ?>');"><?php if (!empty($row['cliente_user_resp'])) { ?><small style="color:red" ><?php echo $row['cliente_user_resp']; ?></small><?php }else{ ?><small style="color:green" >Disponivel</small><?php } ?></td>
<td class="td-actions text-right">
<button type="button" rel="tooltip" class="btn btn-info btn-just-icon btn-sm">
<i class="material-icons">person</i>
</button>
</td>
</tr>
}
</tbody>
</table>
</div>
Use to create a listing with table, when passing 1000 ~ 3000 entries in the database it takes to load even drops, even putting LIMIT what can I do to solve this?