optimizing the code to limit the number of rows

  • taiyabs

    (@taiyabs)


    12 years, 10 months 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….

  • The topic ‘optimizing the code to limit the number of rows’ is closed to new replies.