I don't how to optimize the code to reduce the rows. if anybody help me out. Thanks in advance.
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....