⚠ In case you've missed it, we have migrated to our new website, with a brand new forum. For more details about the migration you can read our blog post for website migration. This is an archived forum. ⚠

  •     

profile picture

Problem with big table



alejf06

alejf06
  • profile picture
  • Member

Posted 10 June 2014 - 17:14 PM

Hello, thank you very much in advance for your help, I'm trying to create a table with 62 fields of which 20 are fields with relationships to other tables, the problem is that when I make the crud with datatables theme get a message: Fatal error: Allowed memory size of 67108864 bytes exhausted (tried to allocate 5754586 bytes) in / home / sp / public_html / system / core / output.php on line 164've tried changing Flexigrid but when exporting to excel I get the problem:
Fatal error: Allowed memory size of 67108864 bytes exhausted (tried to allocate 79 bytes) in / home / sp / public_html / system / database / drivers / mysql / mysql_result.php on line 168
I've tried changing the php.ini or. htacces to give more memory but I can not solve my problem.

 

 
can someone help me?

 


Amit Shah

Amit Shah
  • profile picture
  • Member

Posted 10 June 2014 - 18:53 PM

well.. will recommend restructuring stuff so you can manage things better.


alejf06

alejf06
  • profile picture
  • Member

Posted 10 June 2014 - 19:48 PM

well.. will recommend restructuring stuff so you can manage things better.

 
well thank you very much for your answer, and if I want to show all fields to capture? how I handle it? right through views?

Amit Shah

Amit Shah
  • profile picture
  • Member

Posted 11 June 2014 - 05:42 AM

Well.. did u look up indexing as an option.. this happens with the system when the stuff aint indexed well.. plus, how many tables are there in the 20 relating tables which have huge volume of data? If there are small tables what you can do is query it.. and create array and change field type of the relating fields to dropdown instead setting relations.

 

plus .. dont do the same using datatables.. use flexigrid.. if u want to use datatables.. then do serverside pagination so it limits the data / conditions...

 

if you still facing problem.. thn its time 2 take it personal.. one 2 one :)

 

Happy GCing :)


alejf06

alejf06
  • profile picture
  • Member

Posted 11 June 2014 - 18:30 PM

Well.. did u look up indexing as an option.. this happens with the system when the stuff aint indexed well.. plus, how many tables are there in the 20 relating tables which have huge volume of data? If there are small tables what you can do is query it.. and create array and change field type of the relating fields to dropdown instead setting relations.

 

plus .. dont do the same using datatables.. use flexigrid.. if u want to use datatables.. then do serverside pagination so it limits the data / conditions...

 

if you still facing problem.. thn its time 2 take it personal.. one 2 one :)

 

Happy GCing :)

tnks ! i will try to solve this.