Mel VIP
Total posts: 126
17 Янв 2014 23:00

With Joomla in debug mode, when I look at the heading on the bottom of the page ‘Database Queries’, I see some errors. Please look at a few examples of the errors circled in red in the attached image. I think it refers to the ‘simple select’ field.

The error description in black says:

“This table has probably a missing index on WHERE equalities and/or JOIN ON column/s or is written in a way that no index can be used, causing a time consuming full table scan”

What can be wrong to cause the errors?

Последние изменения: 02 Март 2014


Sergey
Total posts: 13,748
20 Янв 2014 00:50

This is of course not Cobalt related. But as i can see there are no indexes on those table. Or no correct indexes. In first case you need index on field published.

And in second you will need either clint_id or enabled field indexed in _template_styles.

But anyway those tables are small and it do not takes much anyway. I would just leave it as it is.

Работает на Cobalt