I ve made new shop with about 6000 products.
Works very slowly.
Im lookng for someone who can help ?
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
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
Can you share what you did to optimize the large stores?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
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
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
http://forum.opencart.com/viewtopic.php?f=24&t=24391
OpenCart commercial mods and development http://spotonsolutions.net
Layered Navigation
Shipment Tracking
Vehicle Year/Make/Model Filter
Correct. The database needs to be optimized, maybe by creating new indexes etc.
Chris, Opencart Developers and Programmers,
Opencart Developers Opencart Programmers
https://www.chrisranjana.com
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.
OpenCart commercial mods and development http://spotonsolutions.net
Layered Navigation
Shipment Tracking
Vehicle Year/Make/Model Filter
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
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.
Chris, Opencart Developers and Programmers,
Opencart Developers Opencart Programmers
https://www.chrisranjana.com
Who is online
Users browsing this forum: paulfeakins and 6 guests
