Block Record Limit / Fatal error problem

[STuDS0N]

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

[Aiwa]

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...

[Grumpy]

~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.

[STuDS0N]

OK thanks guys, looks like multiple pages/blocks is the only way