[web2py] Re: Why web2py App performance has degraded all of sudden with SQLLITE

2021-11-08 Thread Tom Clerckx
Hi Sandeep, A bit a late reply, but it may be useful for someone later-on. I recently had the exact same issue, quite suddenly, things started to become slow. Here's what I did to solve it: *First thing to do:* make a backup of your project! *Second thing* to do is to vacuum your db, which doe

[web2py] Re: Why web2py App performance has degraded all of sudden with SQLLITE

2020-05-02 Thread John Bannister
Hi Sandeep, Would be good if you can supply a bit more information in order to help you find the solution. questions: 1: Has your database grown recently? 2: Is web2py slow on all queries or just on some tables? 3: Can you use _lasesql to see your sql calls and timings? 4: Are you using SQLFORM