I'm running a Django 1.3 site with Sqlite, and it's very slow on the first database query. I have several other Django sites set up with similar configuration, but using other databases. WebFaction allows persistent Python processes, so I guess it's reloading the Sqlite DB?
Visiting the home page is consistently quick: http://www.simplavortaro.org
Doing a search, which requires a DB connection, takes ~5 seconds on the first search: http://www.simplavortaro.org/?ser%C4%89o=vortaro
Source code is on GitHub.
asked Sep 18 '12 at 13:33
If you're trying to figure out where the slowdown is occurring, then try profiling your code. The profiler results will show you where your code is spending the most time, which should give you a better indication of what the root cause is. The following URLs have a lot of good information on this subject:
Hope that helps!
answered Sep 19 '12 at 15:41