Very large DB issue (Fatal error)

sebdesignlondon

Hi,

I'm trying to load a large of data into a editor table. (300k lines).

I get this error :

Fatal error: Allowed memory size of 134217728 bytes exhausted (tried to allocate 4096 bytes) in /var/www/dashboard/www/assets/js/lib/editor/php/Database/Driver/Mysql/Query.php on line 104

Anybody know how to solve this ?

Thanks

tangerine

It's a PHP out-of-memory error, not DataTables' fault.
Search the forum for "Allowed memory size".

allan

With a 300k table I would strongly recommend enabling server-side processing. The Editor libraries you are using have server-side processing support built in. There is an example available here.

Allan