Speed up Opencart store with thousand of Categories

Job ID: 33940592

Budget: $30 – $250 USD

Hi to all...

I have an Opencart store that currently has about 700 categories - subcategories.
I will need to massively upload new categories and probably will reach the amount of about 5000-10000 categories-subcategories.

Would like to know if this will have an impact on the store and what specific steps we can take to reduce this speed impact.

Ofcourse store is on a good VPS (large memory) and already cache is used.

I need to know about specific code improvement steps.

Thanks.
Related categories: PHP MySQL HTML Open Cart