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 am no longer active around here, to reach me, contact: email@example.com
My latest Freeware Opencart LIGHT Testsite, available on demand: http://www.ebikes.li/shop/
My 888 FREE OC Extension-Repositories - from OC v.1.5.x up,
on the largest OC Extension Github Site: https://github.com/IP-CAM
Users browsing this forum: No registered users and 6 guests