Back office products page wont load - Huge category database preventing it ?

[Vaupell]

When trying to click the products page, it wont load 

 

I'm just getting the classic memory limit error at 264mb, 

So I increased the memory limit to 512mb, and the new error comes at 536mb

Fatal error: Allowed memory size of 536870912 bytes exhausted (tried to allocate 256 bytes) in /var/www/vhosts/mylaggywebsite/httpdocs/classes/db/DbPDO.php on line 103

My the webhost ofcourse prevents going any higher than that.

 

So that is a HUGE/MAJOR problem meaning the site is useless,

since products cannot be added/deleted/modifyed anymore.

 

The categories is a database designed on a OCcommerce platform running only 128mb, and then migrated to Prestashop running 256mb default.

 

The front office works fine, categories and existing products show as they should,

and running it all in a development inviroment it can work both BO and FO.

 

The category database is about cars and are actually buildt up in this syntax

Brand>model>Engine Size>Year><---multiple subcategories here for spareparts-->

 

 

I'm confident the problem with the backoffice product page NOT loading even though it should only

load 50 products at a time, it tries to load ALL categories and ALL products at once.

Which ofcourse is just a design/coding flaw.

 

 

Does anyone have any suggestions on how to sort this problem, or just make a workaround

to actually make the products page work, so it would be possible to edit products ?

[Vaupell]

Update 

 

Did a test in a Dev inviroment, with a php limit of 1gb, but then i got errors on 
Memory errors classes\helper\HelperTreeCategories.php 

 

Set the new server php limit to 4gb then got time outs,

Set the new timeout to 300 instead of 30, 

 

the result is now only a white page no errors, allready have dev mode enabled..

 

Clueless! Any suggestions.

[Vaupell]

Almost everything works.

 

Except we still can't access products "AT ALL" it just crashes,

We can browse the categories just fine, and they still all work fine in the front office.

 

However, if i try to edit or add a category i get this error

 

Fatal error: Maximum execution time of 90 seconds exceeded in D:\xampp\htdocs\HJA\classes\tree\Tree.php on line 240

 

Tree.php

 

is also the thing causing problems for the products, because i can open a single product through the "backway"

through monitoring and selecting a product there ofcourse it cannot be modified because it wants to access the

categories and end up erroring anyway.

 

Still clueless.

 

 

EDIT -  

 

Also adding a screenshot of a random part of the categories db...

 

 

hoping that someone can see if there is something wrong there.

Edited October 6, 2014 by Vaupell (see edit history)