WordPress.org

Ready to get started?Download WordPress

Forums

optimizing the code to limit the number of rows (1 post)

  1. taiyabs
    Member
    Posted 3 years ago #

    Hi there,

    I don't how to optimize the code to reduce the rows. if anybody help me out. Thanks in advance.

    Details given:

    Most common queries

    Time: 93% (114315 sec)
    Amount: 25% (213 queries)
    Rows Examined/Sent: 4343390000 / 1229551
    Avg. Query Exec/Lock Time: 536 / 0 sec.

    My hosting said...

    From the log that was provided you are, on average, examining 20391502 rows of data per query. For a shared hosting company this is to much. I would recommend either optimizing the code to limit the number of rows it examines....

Topic Closed

This topic has been closed to new replies.

About this Topic

Tags

No tags yet.