Fatal Memory Error

I am trying to load a page and I keep getting this error:

Fatal error: Allowed memory size of 134217728 bytes exhausted (tried to allocate 12288 bytes) in /var/www/html/webassist/mysqli/rsobj.php on line 188

The page is a table that shows the data from a query. There is not uploads on the page. Just the data. Any help would be appreciated. Thanks

How many results are you trying to show from the table?

3330 records

It is probably just running out of memory trying to retrieve that many records.

You can either limit the number of records displayed on the page and add pagination, or increase the memory limit, or refine the query if it includes columns you aren't using to reduce the memory load.

I am using the Data tables script which has pagination and I optimized the query to only pull the fields that I needed.

In that case your best bet is to increase your memory limit.

ini_set('memory_limit','512M');

The problem with javascript data tables is that they load the entire data set into the DOM to allow things like pagination and sorting without hitting the server. That is ok for smaller data sets, but html and javascript isn't as efficient as a database for handling larger data sets.

Even once you get this working, you will probably see a delay when loading the page and working with the data table.