Jump to content


Problem with big table

big database memory fatal error

  • Please log in to reply
4 replies to this topic

#1 alejf06

alejf06

    Newbie

  • Members
  • Pip
  • 7 posts

Posted 10 June 2014 - 05: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?

 



#2 Amit Shah

Amit Shah

    grocery CRUD Master

  • Advanced Member
  • PipPipPip
  • 1,192 posts
  • LocationMumbai, India

Posted 10 June 2014 - 06:53 PM

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



#3 alejf06

alejf06

    Newbie

  • Members
  • Pip
  • 7 posts

Posted 10 June 2014 - 07: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?


#4 Amit Shah

Amit Shah

    grocery CRUD Master

  • Advanced Member
  • PipPipPip
  • 1,192 posts
  • LocationMumbai, India

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 :)



#5 alejf06

alejf06

    Newbie

  • Members
  • Pip
  • 7 posts

Posted 11 June 2014 - 06: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.







Also tagged with one or more of these keywords: big, database, memory, fatal error

0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users