Post by Photospirit » Fri Apr 21, 2017 9:35 pm

Hi,
I've a shop at www.speedone.ch with quite some mods integrated. The most important function is the car selection module on the front-page to filter the products matching to the selected car. This filters works fine, but just very slow if no caching module is enabled. Means, when I select a car brand (eg. Audi) then I need to wait 2-3 minutes until the relevant models are ready to select.

On http://test.speedone.ch I have the same shop without caching mod. enabled to see the effect.

Just to enable the caching mod. is not the final solution, as every time the cache is rebuilt the customer has to wait again...

The devloper of the module stated there's no other solution than using the cache module, which I hardly can believe...
Seems to be an SQL Query issue...just guessing...

Currently I have around 4'000 products. These products are assigned to the relevant cars, which ends up in a "product to car" table with around 400'000 entries.
Size of Db is only about 22 MB.... so no tragedy here

So I guess I need a SQL/DB/Performance/OC Specialist ?

Happy to discuss your proposals...
Thanks, Chris

New member

Posts

Joined
Sat Oct 23, 2010 8:16 pm

Post by shivankagrawal » Fri Apr 21, 2017 10:48 pm

Hello Chris,
Please check my PM and let me know. I have relevant experience in Opencart and ready to help you.
Looking forward to your reply.

Thanks,
Shivank Agrawal
skype: anaisys.technologies
email: md@anaisystechnologies.com

Thanks,
Shivank Agrawal
skype: anaisys.technologies
www: anaisystechnologies.com


User avatar
Active Member

Posts

Joined
Mon Jul 18, 2016 7:05 pm
Location - India

Post by Thomas005 » Sat Apr 22, 2017 10:48 pm

Greetings!
I have seen your requirement & I have sent you PM please check .
Regards,
Thomas Johnson

Warm Regards ,
Thomas Johnson
Skype : Thomas.cis
***We do it Better***


Active Member

Posts

Joined
Sat Apr 05, 2014 3:43 pm
Who is online

Users browsing this forum: No registered users and 14 guests