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.
I'm rarely still active at the OC Forum. To reach me, contact: firstname.lastname@example.org
A Demoversion of my free OpenCart LIGHT v.184.108.40.206 Software Edition
can be seen in real Action here: http://www.jti.li/shop/
1'000+ FREE OC Extension-Repositories - from OC v.1.5.x up,
on the world's largest OC-related Github Site: https://github.com/IP-CAM
Users browsing this forum: No registered users and 8 guests