get '/users/transactions.json' を早くする

euglena1215 / isucon9q

Apache License 2.0

0 stars 0 forks source link

Closed ykamez closed 5 years ago

ykamez commented 5 years ago

get '/users/transactions.json'を早くする

ykamez commented 5 years ago

 16 SELECT * FROM `items` WHERE `seller_id` = S AND `status` IN (S, S, S) ORDER BY `created_at` DESC, `id` DESC LIMIT

がとりあえず遅いので、直す ↓これも、N+1 で呼ばれているので怪しげ

  13 SELECT * FROM `users` WHERE `id` = S