Somewhere in your code you are probably fetching all the rows.
Look at all your queries and see whether you can paginate results
somehow (using limitby).
Look at IS_IN_DB validators etc which create drop down boxes and
consider using sub-sets of data to populate them,  or replace with
autocomplete.

Without seeing any code,  it is difficult to be specific.

Regards, D

On Mar 9, 5:52 pm, Philip <philip.el...@gmail.com> wrote:
> 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

Reply via email to