You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
nothing to worry that bad about, nevertheless, in my mysql log the query
SELECT option_value, option_name FROM piwik_option WHERE autoload = 1;
appeared. This query does not use an index on the column autoload. As it contains not that much stuff the performance issue is not that dramatic but it gives spaces for optimisation at this point.
Or have there been any special reasons which I did not consider, yet?
rgrds
Peter
The text was updated successfully, but these errors were encountered:
Well in this specific case i just checked with this one parameter autoload for selection and setting an additional indey for this column.
Maybe its worth a check to do an explain select on this query with both types of indexes and an in case the index of both fields does fine, too just measure the qeuery speed.
Hey guys,
nothing to worry that bad about, nevertheless, in my mysql log the query
SELECT option_value, option_name FROM
piwik_option
WHERE autoload = 1;appeared. This query does not use an index on the column autoload. As it contains not that much stuff the performance issue is not that dramatic but it gives spaces for optimisation at this point.
Or have there been any special reasons which I did not consider, yet?
rgrds
Peter
The text was updated successfully, but these errors were encountered: