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 Personal OC Forum Messages, contact: firstname.lastname@example.org
Test Site: http://www.bigmax.ch/shop/
Github OC Downloads: https://github.com/IP-CAM
2'200+ FREE OC Extensions from the World's largest Github OC Repository Archive.
Users browsing this forum: No registered users and 3 guests