100 thousand products - very long loading time

Good morning,
at 100 thousand products, all eshop add-ons - modules and components take a very long time to load. I noticed that there are duplicate queries 90% of the load is modules and component. After turning them off - everything is ok. I tried to modify the number of repetitions and use cache on the database. Can anyone suggest a solution?

Hi Mrpl

I would like to optimize the queries to make it faster and work with this large number of products. If it is possible, could you please export the Eshop database tables from your installation, then zip it and upload somewhere, then submit a support ticket sending us link to download?

We will then restore it on our local installation and optimize Eshop to make it works faster

Regards,

Tuan

Thank you for your answer, I sent a link to the structures and data from the database in the ticket

Thank you Mrpl!

Yes, we received it. We need the time to check and optimize EShop in this case. We will work and get back to you via ticket system once we have updates.

Have a nice weekend!

Sincerely, Giang

Thanks. We received it. Please be patient and wait for us. We are going to work hard to find a solution

Tuan

good morning, a few days ago I wrote a private message (ticket), I have not received a reply yet. Please provide feedback - it is very urgent.

Hello Mrpl,

We have been still working to improve performance of EShop when the store volumn is abount 100K products. We will try to give you update via ticket system soon.

Sincerely, Giang

Will it be possible to get answers to a few questions in the ticket?

Dear Mrpl,

We will try to get back to you via ticket soon.

Sincerely, Giang

EShop has been updated and it is definitely faster!