Problem

When exporting language resource usage logs in the clients overview and in case that there are a lot of usage log entries in the table, the export request will crash with out of memory.

Our temp solution for some clients is to increase the memory in installation.ini to 4GB.

Solution

The reason for out of memory is the php excel library (well known as memory hungry) which we are using for this. Internally the library holds the indexes for each column in 2d array. And the export crashes when native php array function is used to get the array keys or values (not sure exactly).

Potential solution:

• find out why this uses so much memory and maybe provide alternative solution for this exact problem
• find another php excel lib which does not run in out of memory
• introduce max amount of data which is hold in this table and clean those tables after 1 month. ex: export usage log once per month(automatically) and sent email attachment to pms with the data. After this clean the data