What this means is that for any store with a large number of products (i.e. 50,000, like in our case) the store would not perform very well.
As the absolute minimum indexes should be defined on
- Foreign key fields by which data is queried or joined
- Fields on which data is filtered (e.g. on Products this would be Price, Status, etc)
Can someone on the core development team please add proper indexes to tables or let me know how I can contribute this into the core.
The Finnish OpenCart Forum
"Real programmers don't document. If it was hard to write, it should be hard to understand."
expect everything, to be built-in already by default, you better
look around for a paid Software, then you might have a reason to.
Please don't send me OC Forum Personal Messages, just contact: firstname.lastname@example.org
OC 18.104.22.168 LIGHT Test Site: http://www.bigmax.ch/shop/
OC 22.214.171.124 V-PRO Test Site: http://www.jacob.ch/shop/
My Github OC Site: https://github.com/IP-CAM
2'250+ FREE OC Extensions from the World's largest Github OC Repository Archive Site.
Users browsing this forum: No registered users and 2 guests