Large Data Issue

nayan

I am using Data table but when i am loading 5000 row from data base it takes 1 to 2 minute and all data are miss managed before load like blinking
my code is

<?php $m=1; $iap_det=$db->get_iap_register_details_form(); //registeDet while ($row=mysql_fetch_array($iap_det)){ // $iap_reg_obj=''; // echo $row['MastCode']; // $iap_reg=$db->get_iap_register_obj_by_mst($row['MastCode']); //register_obj // $iap_reg_obj=mysql_fetch_array($iap_reg); // print_r($iap_reg_obj[0]."dsdsd"); ?> <?php $m++; } ?>

	SNo	Fin. Year	Internal Audit Memo No	Date of Objection	Assessee Name	Pan No	Scan File 1	Scan File 2	Asst. Year	Block Asst.	Block Asst. Period	Tax Effect	Type	Group	Gist Of objection	Status	CCIT Charge	CIT Charge	Audit Party	Audit Party Type	Range	Assessing Officer	User	Entry Date	Type
" >	<?php echo $m;?>	<?php $ay=$db->get_year_by_id($row['FinYearCode']); if($asst=mysql_fetch_array($ay)){ echo $asst['year']; } ?>	<?php echo$row['LARIAMNo']; ?>	<?php echo $row['DOAO1']; ?>	<?php echo $row['AssName']; ?>	<?php echo $row['PanNo']; ?>	<?php echo $row['ScanFile1']."pdf"; ?>	<?php echo $row['ScanFile2']."pdf"; ?>	<?php $ayy=$db->get_year_by_id($row['AssYearCode']); if($assty=mysql_fetch_array($ayy)){ echo $assty['year']; } ?>	checked <?php } else { }?> disabled>	<?php echo $row['BlockAsstPeriod']; ?>	<?php echo $row['TaxEffect']; ?>	<?php echo $row['MajorMinor']; ?>	<?php echo $row['AssGroup']; ?>	<?php echo $row['GOObjection']; ?>	<?php echo $row['StatusCode']; ?>	<?php $t=$db->get_ccit_by_id($row['CCITCode']); if($toc=mysql_fetch_array($t)){ echo $toc['ccit_charge']; } ?>	<?php $a_o=$db->get_cit_by_id($row['CITCode']); if($oc=mysql_fetch_array($a_o)){ echo $oc['cit_charge_name']; }?>	<?php $t=''; // echo $row['audit_party_code']; $ap=$db->get_ap_by_id($row['APCode']); if($aap=mysql_fetch_array($ap)){ echo $aap['party_name']; $t=$aap['apt_name']; } //echo $row['range_code']; ?>	<?php echo $t; ?>	<?php $ran=$db->get_range_by_id($row['RangeCode']); if($rang=mysql_fetch_array($ran)){ echo $rang['range_name']; } //echo $row['range_code']; ?>	<?php $aos=$db->get_ao_by_id($row['APCode']); if($aoos=mysql_fetch_array($aos)){ echo $aoos['name']; } //echo $row['range_code']; ?>	<?php echo $row['UserCode']; ?>	<?php echo $row['EntryDate']; ?>	<?php echo $row['ObjType']; ?>

$(document).ready(function() {
$('#example1').dataTable({
"scrollY": "400px",
"scrollX": "400px",
"scrollCollapse": true,
"paging": false
//"jQueryUI": true
});

tangerine

Please present your code in a readable fashion using Markdown.

http://datatables.net/manual/tech-notes/8

allan

Also, please link to a test case showing the issue, as per the forum rules.

Allan