Thank you to both of you. Anthony I was using redis to handle my sessions hence I can discard that bottleneck besides I need the session info on my components.
It seems that web2py performs more querys to the database than expected. I have the database on digitalocean but was using web2py on my machine. I tried deploying the app in the same server of the database and now it is more responsive. I have reduced the time a component is loaded from 5-6 seconds to 1.30 seconds max. I wasn't expecting this since I think the same quantity of information travels through internet on both cases [(local browser + local web2py ---- internet db) ~ (local browser ---- internet web2py + internet db)] unless web2py makes more calls to the db than I supposed it to do. Finally, is 1.30 seconds a good speed? My components perform only selects to tables with no more than 5 records so I don't think it is an application issue. Is it ok? Thank you El miércoles, 19 de julio de 2017, 11:51:22 (UTC-5), Bernardo Leon escribió: > > Hi, I am facing a problem with performance. I have a view with four LOAD > calls that is taking almost 15 seconds to load. I know that two of this > components are loaded after the two first LOAD calls but 15 seconds is > still too much time. So I profiled the execution of my view and end up with > the runpythonrun image I am attaching. > > This is my DAL definition: > > db = DAL(gth_dev_db_connection_string, > lazy_tables=True, > pool_size=15, > migrate=False) > > And I don't have functions on my model file (I am importing them from > modules). > > What could be the problem? > > Thank you! > > > -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) - https://code.google.com/p/web2py/issues/list (Report Issues) --- You received this message because you are subscribed to the Google Groups "web2py-users" group. To unsubscribe from this group and stop receiving emails from it, send an email to web2py+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/d/optout.
