OpenCart Community

I ve made new shop with about 6000 products.
Works very slowly.
Im lookng for someone who can help ?

Pretty useless information without a link

hello ,

Open cart can be highly scalable .

we have recently optimized to handle multiple stores with more than two hundred thousand products .

please share the link and customization history details .

Thanks and regards ,

Karan Ahuja

www.kodeplay.com
www.kodemall.com

karan2 wrote:hello ,

Open cart can be highly scalable .

we have recently optimized to handle multiple stores with more than two hundred thousand products .

please share the link and customization history details .

Thanks and regards ,

Karan Ahuja

http://www.kodeplay.com
http://www.kodemall.com

Can you share what you did to optimize the large stores?

Thanks

the large database was pulled from an erp system , so most of the optimizations were involving the erp database schema as well

we will try to isolate the erp db schema and publish the optimizations soon .

Thanks and regards ,

Karan Ahuja
www.kodeplay.com
www.kodemall.com

well I have a thread about database optimization which greatly speeds things up under certain circumstances.

http://forum.opencart.com/viewtopic.php?f=24&t=24391

Correct. The database needs to be optimized, maybe by creating new indexes etc.

if you read the thread I linked it's not indexes. the queries simply need to be changed around a bit to take better advantage of existing indexes.

All the indexes xsecrets originally mentioned were added to 1.4.9.0 so it should have improved from those already

The second step regarding changing around the queries is also under test but seems everyone with a large enough store to test it never replies with results

Maybe we can create an auto populating script for populating large amount of sample data and test the speeds.