Streamline Rating
Brought to you by:
darrenkw
Menu
▾
▴
#3 Streamline Rating
Handler_read_rnd 427 M The number of requests to read a row based on a fixed position. This is high if you are doing a lot of queries that require sorting of the result. You probably have a lot of queries that require MySQL to scan whole tables or you have joins that don't use keys properly.
Handler_read_rnd_next 3.84 G The number of requests to read the next row in the data file. This is high if you are doing a lot of table scans. Generally this suggests that your tables are not properly indexed or that your queries are not written to take advantage of the indexes you have.
during rating, this is happening, which leads me to believe we need to review how we rate and see if we can optimize it
Logged In: YES
user_id=1893410
Originator: NO
most time is spent during routes check during rating, with 15000 routes in a pricelist it takes about 4 seconds