STuDS0N Posted August 5, 2014 Share Posted August 5, 2014 I am trying to pull a large number of record entries from a database feed into a block to allow sorting/filtering. I use the datatables script to display my table but I'm running into problems once I try to pull more than 700 or so records from the database. The page I am building is here: http://www.e-athlete.net/Madden15PlayerRatings/ratings Support is saying it would use too many resources which is why I am getting the errors below. Just wondering if anyone has any other suggestions or ideas other than making separate pages for each of the teams/positions I am trying to filter with. Fatal error: Allowed memory size of 134217728 bytes exhausted (tried to allocate 1373051 bytes) in/home/eathlete/public_html/ips_kernel/classDb.php on line 1651 Fatal error: Allowed memory size of 134217728 bytes exhausted (tried to allocate 94 bytes) in/home/eathlete/public_html/admin/applications_addon/ips/ccs/extensions/content/feed_blocks/databases.phpon line 1167 Link to comment Share on other sites More sharing options...
Aiwa Posted August 5, 2014 Share Posted August 5, 2014 700 records is a lot.... Not sure how you have your data structured, but you could break it up into smaller blocks, 100-300 records each and see what that gets you... Link to comment Share on other sites More sharing options...
Grumpy Posted August 5, 2014 Share Posted August 5, 2014 ~134MB for 700 records? Sounds rather something inefficient going on. Also, you should do your sort and filter as much as possible at the database level instead of php. You're just dealing with more rows than you need to. Link to comment Share on other sites More sharing options...
STuDS0N Posted August 5, 2014 Author Share Posted August 5, 2014 OK thanks guys, looks like multiple pages/blocks is the only way Link to comment Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.