I have 1000 records in mysql datatable. when load the 1000 records in my table sometime there are stucking.. I want to load all records at once but one time 10 records after load 10 records next end of the records. I'm using ajax load method, php and mysql. Please help me to resulve that problems...
<script src="https://cdnjs.cloudflare.com/ajax/libs/jquery/3.3.1/jquery.min.js"></script>
$('#main_operators').on('click',function(){
let date_from = $('#from_date').val();
let date_to = $('#to_date').val();
> before loading will show gif file
$('#main_page').html('<div ><img src="../imges/prossecing.gif" class="rounded mx-auto d-block" alt="..."></div>');
> result loading div
$('#main_page').load('result_table.php')
});