Response time
# avo-2m
microscopic-dream-82397
09/05/2023, 8:07 PMHey guys. What is the browser response time for an #index action, paginated with 24 records, without relationships and using PostgreSQL, disregarding a cold start?
l
loud-jewelry-99127
09/06/2023, 4:08 AMHi @microscopic-dream-82397 I think there isn't a fixed value, it depends on many factors like the browser, server's configuration and capacity etc...
m
microscopic-dream-82397
09/06/2023, 8:24 AMUsing Beeline's Honeycomb APM tool I identified that most of the time to respond occurs in the processing of "action_view render_layout" with "action_view render_template" inside. It seems to be a disproportionate amount of time, much longer than other parts of the code take to execute. I don't know if it would be possible to cache or improve performance for a system with different user profiles that display or hide attributes according to permissions
microscopic-dream-82397
09/06/2023, 8:25 AMhttps://cdn.discordapp.com/attachments/1148711116340461598/1148896695501979688/SAVE_20230906_052504.jpg▾
l
lemon-wall-20836
09/06/2023, 1:44 PMcan you reproduce that locally with something like
rack-mini-profilerlemon-wall-20836
09/06/2023, 1:44 PMwe'd love to have a look, but nothing compute-heavy comes to mind there
lemon-wall-20836
09/06/2023, 1:44 PMnot saying there isn't, but if there is something on our end it should be easy to pinpoint and reproduce
m
microscopic-dream-82397
09/06/2023, 2:39 PMWith rack mini
microscopic-dream-82397
09/06/2023, 2:40 PMhttps://cdn.discordapp.com/attachments/1148711116340461598/1148991166289809458/image.png▾
l
lemon-wall-20836
09/06/2023, 2:41 PMcan you create a reproduction repository with rack mini so we can investigate locally?
m
microscopic-dream-82397
09/06/2023, 2:52 PMAdded to SIA private repository. The instructions are in the README, but in Portuguese
l
loud-jewelry-99127
09/06/2023, 2:55 PMLet me know if translation is required 🙂
l
lemon-wall-20836
09/06/2023, 2:55 PMcan you please invite Paul too? he'll have the first look 😛
m
microscopic-dream-82397
09/06/2023, 2:57 PMalready added
l
loud-jewelry-99127
09/06/2023, 2:57 PMObrigado 🙂
m
microscopic-dream-82397
09/06/2023, 2:58 PMDe nada
microscopic-dream-82397
09/06/2023, 2:58 PMadmin@teste.com / admin123
microscopic-dream-82397
09/06/2023, 2:59 PMusers in /db/seeds/0040_usuarios.rb
microscopic-dream-82397
09/12/2023, 1:57 PMGood morning guys. After some attempts to find the cause of the delay with slower requests
microscopic-dream-82397
09/12/2023, 1:58 PMUsing different tools like stackprof, rbspy rack-mini-profiler, Jaeger APM
microscopic-dream-82397
09/12/2023, 2:02 PMThey all indicated that the delay is related to the process of rendering index.html.erb and using application.html.erb
microscopic-dream-82397
09/12/2023, 2:03 PMBut I believe there is nothing you can do as a user, it would have to be an optimization process by someone who understands AVO deeply
microscopic-dream-82397
09/12/2023, 2:05 PMI read some articles about caching and partials, but these changes can bring benefits as well as unwanted side effects
microscopic-dream-82397
09/12/2023, 2:07 PMIt's not a very long response time, but I believe it can be optimized, perhaps using threads/fibers, or code refactoring with more optimized methods
microscopic-dream-82397
09/12/2023, 2:11 PMI created a gist with the survey, but unfortunately I don't know enough about Ruby on Rails to help
microscopic-dream-82397
09/12/2023, 2:12 PMl
loud-jewelry-99127
09/13/2023, 6:05 AMHi @microscopic-dream-82397 we appreciate your investigation efforts here! We're focusing on avo3 release right now. Will get some time after november.
I believe we should focus on improving performance without caching at first... Caching, as you mentioned can bring some unwanted side effects, like outdated data, which would be far from ideal. However there can be sections on our code where caching would not bring that side effect, we should carefully analyze them.
Again, great investigation and thank you a lot for the report. We will give it more thorough attention when we have the available time.
m
microscopic-dream-82397
09/13/2023, 12:01 PMThank you, Paulo. AVO is getting better and better and version 3 brought many improvements and features. Congratulations to the team!