Index not used.

  • stofa

    (@stofa)


    7 years, 9 months ago

    Hi,

    The plugin has a huge impact on the database when the wp_vc_log table is large.
    With the following queries :

    SELECT COUNT(*) FROM wp_vcp_log WHERE DATE(Time)=DATE(NOW() – INTERVAL 1 DAY)

    SELECT COUNT(*) FROM wp_vcp_log WHERE WEEKOFYEAR(Time)=WEEKOFYEAR(NOW())

    SELECT COUNT(*) FROM wp_vcp_log WHERE MONTH(Time)=MONTH(NOW())

    No index on Time column is used.

    In order to use an index, the left part in the WHERE clause ( before = sign ) cannot contain a function but only the column name.

    Thanks,

    Stofa.

The topic ‘Index not used.’ is closed to new replies.