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 don't use Forum Mail, to reach me, contact: email@example.com
Server Q & A Basic Information on Code + Settings
Demoversion OpenCart LIGHT v.18.104.22.168
1'400+ FREE OC Extensions - 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 4 guests