N+1 problem when loading encode.file encode.thumbnail

[x1wins]

N+1 problem when loading encode.file encode.thumbnail

[x1wins]

i did down response time from 659ms to 227ms with using with_attached_file, with_attached_thumnails
https://github.com/rails/rails/tree/master/activestorage#examples

web_1      | Started GET "/encodes" for 172.21.0.1 at 2020-08-01 00:31:21 +0000
web_1      | Cannot render console from 172.21.0.1! Allowed networks: 127.0.0.0/127.255.255.255, ::1
web_1      | Processing by EncodesController#index as HTML
web_1      |   User Load (2.1ms)  SELECT "users".* FROM "users" WHERE "users"."id" = $1 ORDER BY "users"."id" ASC LIMIT $2  [["id", 1], ["LIMIT", 1]]
web_1      |   Rendering encodes/index.html.erb within layouts/application
web_1      |   Encode Load (2.8ms)  SELECT "encodes".* FROM "encodes" WHERE "encodes"."published" = $1 ORDER BY id DESC LIMIT $2 OFFSET $3  [["published", true], ["LIMIT", 20], ["OFFSET", 0]]
web_1      |   ↳ app/views/encodes/index.html.erb:17
web_1      |   ActiveStorage::Attachment Load (3.7ms)  SELECT "active_storage_attachments".* FROM "active_storage_attachments" WHERE "active_storage_attachments"."record_type" = $1 AND "active_storage_attachments"."name" = $2 AND "active_storage_attachments"."record_id" IN ($3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13, $14, $15, $16, $17, $18, $19, $20, $21, $22)  [["record_type", "Encode"], ["name", "file"], ["record_id", 167], ["record_id", 166], ["record_id", 165], ["record_id", 164], ["record_id", 163], ["record_id", 162], ["record_id", 161], ["record_id", 160], ["record_id", 159], ["record_id", 158], ["record_id", 157], ["record_id", 156], ["record_id", 155], ["record_id", 154], ["record_id", 153], ["record_id", 152], ["record_id", 151], ["record_id", 150], ["record_id", 149], ["record_id", 148]]
web_1      |   ↳ app/views/encodes/index.html.erb:17
web_1      |   ActiveStorage::Blob Load (2.9ms)  SELECT "active_storage_blobs".* FROM "active_storage_blobs" WHERE "active_storage_blobs"."id" IN ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13, $14, $15, $16, $17, $18, $19, $20)  [["id", 329], ["id", 331], ["id", 337], ["id", 340], ["id", 346], ["id", 352], ["id", 358], ["id", 364], ["id", 370], ["id", 377], ["id", 384], ["id", 391], ["id", 392], ["id", 399], ["id", 406], ["id", 413], ["id", 420], ["id", 427], ["id", 434], ["id", 441]]
web_1      |   ↳ app/views/encodes/index.html.erb:17
web_1      |   ActiveStorage::Attachment Load (3.8ms)  SELECT "active_storage_attachments".* FROM "active_storage_attachments" WHERE "active_storage_attachments"."record_type" = $1 AND "active_storage_attachments"."name" = $2 AND "active_storage_attachments"."record_id" IN ($3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13, $14, $15, $16, $17, $18, $19, $20, $21, $22)  [["record_type", "Encode"], ["name", "thumbnails"], ["record_id", 167], ["record_id", 166], ["record_id", 165], ["record_id", 164], ["record_id", 163], ["record_id", 162], ["record_id", 161], ["record_id", 160], ["record_id", 159], ["record_id", 158], ["record_id", 157], ["record_id", 156], ["record_id", 155], ["record_id", 154], ["record_id", 153], ["record_id", 152], ["record_id", 151], ["record_id", 150], ["record_id", 149], ["record_id", 148]]
web_1      |   ↳ app/views/encodes/index.html.erb:17
web_1      |   ActiveStorage::Blob Load (2.6ms)  SELECT "active_storage_blobs".* FROM "active_storage_blobs" WHERE "active_storage_blobs"."id" IN ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13, $14, $15, $16, $17, $18, $19, $20, $21, $22, $23, $24, $25, $26, $27, $28, $29, $30, $31, $32, $33, $34, $35, $36, $37, $38, $39, $40, $41, $42, $43, $44, $45, $46, $47, $48, $49, $50, $51, $52, $53, $54, $55, $56, $57, $58, $59, $60, $61, $62, $63, $64, $65, $66, $67, $68, $69, $70, $71, $72, $73, $74, $75, $76, $77, $78, $79, $80, $81, $82, $83, $84, $85, $86, $87, $88, $89, $90, $91, $92, $93, $94, $95, $96, $97, $98, $99)  [["id", 330], ["id", 332], ["id", 333], ["id", 334], ["id", 335], ["id", 336], ["id", 338], ["id", 339], ["id", 341], ["id", 342], ["id", 343], ["id", 344], ["id", 345], ["id", 347], ["id", 348], ["id", 349], ["id", 350], ["id", 351], ["id", 353], ["id", 354], ["id", 355], ["id", 356], ["id", 357], ["id", 359], ["id", 360], ["id", 361], ["id", 362], ["id", 363], ["id", 365], ["id", 366], ["id", 367], ["id", 368], ["id", 369], ["id", 371], ["id", 372], ["id", 373], ["id", 374], ["id", 375], ["id", 376], ["id", 378], ["id", 379], ["id", 380], ["id", 381], ["id", 382], ["id", 383], ["id", 385], ["id", 386], ["id", 387], ["id", 388], ["id", 389], ["id", 390], ["id", 393], ["id", 394], ["id", 395], ["id", 396], ["id", 397], ["id", 398], ["id", 400], ["id", 401], ["id", 402], ["id", 403], ["id", 404], ["id", 405], ["id", 407], ["id", 408], ["id", 409], ["id", 410], ["id", 411], ["id", 412], ["id", 414], ["id", 415], ["id", 416], ["id", 417], ["id", 418], ["id", 419], ["id", 421], ["id", 422], ["id", 423], ["id", 424], ["id", 425], ["id", 426], ["id", 428], ["id", 429], ["id", 430], ["id", 431], ["id", 432], ["id", 433], ["id", 435], ["id", 436], ["id", 437], ["id", 438], ["id", 439], ["id", 440], ["id", 442], ["id", 443], ["id", 444], ["id", 445], ["id", 446], ["id", 447]]
web_1      |   ↳ app/views/encodes/index.html.erb:17
web_1      |    (2.8ms)  SELECT COUNT(*) FROM "encodes" WHERE "encodes"."published" = $1  [["published", true]]
web_1      |   ↳ app/views/encodes/index.html.erb:37
web_1      |   Rendered encodes/index.html.erb within layouts/application (Duration: 79.4ms | Allocations: 29715)
web_1      | [Webpacker] Everything's up-to-date. Nothing to do
web_1      |   Rendered layouts/_header.erb (Duration: 11.5ms | Allocations: 705)
web_1      |   Rendered layouts/_menu.erb (Duration: 0.4ms | Allocations: 208)
web_1      | Completed 200 OK in 227ms (Views: 201.2ms | ActiveRecord: 20.6ms | Allocations: 38504)