My listing is taking a long time to load

1
<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?

    
asked by anonymous 02.05.2018 / 14:34

0 answers