Slow load in DataTable

foxxtec

Hello,

First I would like to apologize for my English. I am Brazilian and I speak very well'm using google translator.

I'm working with 1800 files and is taking too long to load. I realized that actually it's not my problem but the settings loading.

how can I do so that when you click on next paging load the files instead of loading all data before showing the table?

[code]
$(".dTable").dataTable({
"bScrollInfinite": true,
"bScrollCollapse": true,
"sScrollY": "200px"
}),
[/code]


[code]



#
<?php echo get_phrase('student');?>
Título
<?php echo get_phrase('Descrição');?>
<?php echo get_phrase('Quantia');?>
<?php echo get_phrase('Status');?>
<?php echo get_phrase('Meses a pagar');?>
<?php echo get_phrase('options');?>


<?php $count = 1;?>

<?php foreach($invoices as $row):?>

<?php echo $count++;?>
<?php echo $this->crud_model->get_type_name_by_id('student',$row['student_id']);?>
<?php echo $row['title'];?>
<?php echo $row['description'];?>
R$ <?php echo $row['amount'];?>

<?php echo $row['status'];?>

<?php echo date($row['meses']);?>


<?php echo get_phrase('Ver Detalhes');?>


<?php echo get_phrase('edit');?>


<?php echo get_phrase('Pagar');?>



<?php endforeach;?>


[/code]

allan

Please see the FAQs: http://datatables.netfaqs#speed .