I have just installed this package and am setting up my first data table display.

I have created a simple query in a 3 column table with 77339 records
SELECT *
FROM `unspsc`

I have attached an image of my column settings

The following error happens when I publish the data table:

Fatal error: Allowed memory size of 67108864 bytes exhausted (tried to allocate 40 bytes) in
/home/freedomg/public_html/administrator/components/com_arismartcontent/kernel/Application/ARISmartContent/Formatters/class.TableFormatter.php on line 39

Here is the System Information


Any help would be appreciated.
Thank you.

I am able to display the data table if I use server side pagination in the module.

My revised questions are now:

Is there some disadvantage to using server side pagination?

Is there something else I should be doing to manage the memory?

Hello,

When "Server side pagination" parameter is disabled, all data is loaded from a database. It is normal for a small dataset, but it causes performance issue with a large dataset. For large datasets using "Server side pagination" is normal. It is common approach to load only part of data (paging is using for this purpose).

Regards,
ARI Soft