I've just reviewed the database structure of OpenCart, and although I think the database is very well designed in terms of good database design principles and consistent naming, I was shocked to find that there were practically NO INDEXES defined on the database with the exception of primary keys.
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.
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.
A very good point - database is the basic data machine behind this all. Hopefully Daniel & core team will see this thread and contact you 

The Finnish OpenCart Forum
"Real programmers don't document. If it was hard to write, it should be hard to understand."
The quickest way is probably to make the changes to opencart.sql and submit it to Daniel though it can unfortunately be rather difficult to get changes included. For existing websites you could release an SQL file making the changes to the board and user mods section.
-Ryan
Well, such an extension exists for Years already, but if you
expect everything, to be built-in already by default, you better
look around for a paid Software, then you might have a reason to.
Ernie
https://github.com/lilalaunesau/opencart-turbo
expect everything, to be built-in already by default, you better
look around for a paid Software, then you might have a reason to.
Ernie
https://github.com/lilalaunesau/opencart-turbo
My Github OC Site: https://github.com/IP-CAM
5'600 + FREE OC Extensions, on the World's largest private Github OC Repository Archive Site.
Who is online
Users browsing this forum: No registered users and 17 guests