i want to load 10k data in my bootstrap data table in codeigniter

Asked Feb 21 '18 at 06:05

Active Feb 21 '18 at 07:51

Viewed 336 times

I have 10000 rows on table in my database. When ever I try to load all my data, page stop working error comes. Is there limit of loading data in data table? And if yes, then how can i increase that limit?

 <?php 
 foreach($recs as $ans)
 {
?>
<tr>                                            
    <td><center><?php echo $ans['sz_StockID']; ?></center></td>
</tr>
<?php
 }
?>

Controller:

$this->check_session();
$data['recs']=$this->am->get_diamonds();

Model:

$q=$this->db->query('select * from `table_name`');
return $q->result_array();

edited Feb 21 '18 at 07:51

Salim Ibrohimi

1,351
3
17
35

asked Feb 21 '18 at 06:05

Shah Vairag

Show us your code and the error – Tree Nguyen Feb 21 '18 at 06:07
error number 500 and i use simple for loop for call data.when there is 2000 data its display all things properly but when data goes up to 2000 error comes @TreeNguyen – Shah Vairag Feb 21 '18 at 06:13
Please edit your post to add your code into that. – Tree Nguyen Feb 21 '18 at 06:14
please check now @TreeNguyen – Shah Vairag Feb 21 '18 at 06:22
What do you mean by `10 000` data? Do you mean you have `10K` rows? – Salim Ibrohimi Feb 21 '18 at 06:24
yes @SalimIbrogimov – Shah Vairag Feb 21 '18 at 06:25
The code that you provide it's doing nothing, but iterates an array, please add more code, which will help us. Thanks! – Salim Ibrohimi Feb 21 '18 at 06:27
please check now controller and model code @SalimIbrogimov – Shah Vairag Feb 21 '18 at 06:32
see the result of: `echo $this->db->error();` – Salim Ibrohimi Feb 21 '18 at 06:35
what's the error? – Tree Nguyen Feb 21 '18 at 06:36
no any error output is: Array ( [code] => 0 [message] => ) @SalimIbrogimov – Shah Vairag Feb 21 '18 at 06:37
Please limit rows, for testing purpose: `$q=$this->db->query('select * from table_name limit 10');` – Salim Ibrohimi Feb 21 '18 at 06:38
1

when i print $data it will show me all on controller but when i send it to view page in data table it will stop working. @SalimIbrogimov – Shah Vairag Feb 21 '18 at 06:41
Okay, how do you passing the `$data` onto `view` from `controller`??? add code if it's possible? – Salim Ibrohimi Feb 21 '18 at 06:42
$this->load->view('controller_name/view_page_name',$data);@SalimIbrogimov – Shah Vairag Feb 21 '18 at 06:44
in `$data` do you have `recs` item ??? – Salim Ibrohimi Feb 21 '18 at 07:01
guys stop talking about nonsense ... he exceeds the memory limit and this is good so - because you should never ever load 10k rows at once ... @Shah Vairag - https://stackoverflow.com/questions/47885399/datatable-with-ajax-is-not-working-well-after-use-serverside-true/47885949#47885949 - study my answer and ops question and you should be able to get a solution – Atural Feb 21 '18 at 07:11
^ or pagination or Ignited Datatables. Never load 10k rows at once, are you suicidal? ;) – Alex Feb 21 '18 at 07:40
@sintakonte he said: `when i print $data it will show me all on controller but when i send it to view page in data table it will stop working` – Salim Ibrohimi Feb 21 '18 at 08:16
1

@Salim fair enough - but it doesn't change the fact that loading 10k rows at once is total nonsense... and this is what i meant, as this discussion went in a wrong direction – Atural Feb 21 '18 at 09:28
@sintakonte: yes, I agree, with you! ))) – Salim Ibrohimi Feb 21 '18 at 09:30
No user will ever compare 10k rows on one screen. Paginate it per 10 or per 100 rows on output. And never query all rows from database but use limit. @sintakonte gave you an example. – Tpojka Feb 21 '18 at 11:43

i want to load 10k data in my bootstrap data table in codeigniter

0 Answers0