[alejf06]

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]

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

[alejf06]

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]

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]

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.