Database SQL Queries table scanning

  • timxjr1300

    (@timxjr1300)


    4 years, 9 months ago

    I have a self hosted wordpress site which has been running for years. It’s all OK.
    Recently I have used PHPMyAdmin to understand how the database is being used and I have come across the “Advisor” facility which suggests improvements that could be made to increase database efficiency.

    It seems that a lot of queries are performing table scans, not using indexes and inefficient joins which are all very bad from a database performance point of view.

    So my general question or observation is…
    When creators write wordpress itself and/or plugins, are they required to ensure that database use is as efficient as possible and use the more efficient database engine rather than inefficient scanning queries?

    • This topic was modified 4 years, 9 months ago by Jan Dembowski. Reason: Moved to Fixing WordPress, this is not an Everything else WordPress topic
Viewing 2 replies - 1 through 2 (of 2 total)
  • corenominal

    (@corenominal)

    4 years, 9 months ago

    Hi 🙂

    Answering your question: no, it is not a requirement to write the most efficient queries possible, although I’m sure many developers aspire to do so.

    Answering your observation: to quote the WordPress site:

    Whether you’re a budding developer, a designer, or just like helping out, we’re always looking for people to help make WordPress even better.

    See Make WordPress for more information.

    Thread Starter timxjr1300

    (@timxjr1300)

    4 years, 9 months ago

    Thanks for your reply

Viewing 2 replies - 1 through 2 (of 2 total)

The topic ‘Database SQL Queries table scanning’ is closed to new replies.