I am having an issue with an application. Page load times are 20+ seconds. This is true for all pages, even in admin functions (as soon you select the application in question). It appears to be a database problem, since the problem appeared after adding about 15,000 records to an application that was working well with far fewer (probably ~2000). I am using sqlite as the backend and running an internal application on a windows server that is also used as a fileshare. The applications has 8 tables, 4 of 5 which have over 2000 records, the largest is about 6000 records. The tables are quite small, so the total db.db file size is still just over 1MB (worked great when it was only 250kB), despite the number of records. Problem occurs both when running locally installed on my machine or over the network to the server-hosted version. In both cases, only one user was using the application.
I have tried migrate=false and compiling the app as the web2py book suggests - no noticable improvement. Looking online for performance and scalability of sqlite, it seems that I am still well under any size that would cause an sqlite performance issue. Does anyone know of any common root causes of performance problems like that? Thanks
