On Fri, 2 Dec 2005, Christopher Schmidt wrote:
I'm already seeing some slowdowns on Boston in some pages, so I may be looking to add some caching to different aspects of the page - specifically, when loading ?action=index;format=map (which is still one of the more common page requests I see), which loads *everything* in the DB, it's slow. So, I think that if we're going to go for the whizbang nature here, loading all the data may be more likely, and SQLite is not going to be scaling "enough".
indexes.
Skip the pain. MySQL isn't that big of a requirement. SQLite may be more painful. Let's not hurt OG by encouraging using a possibly non-scaling database product which users would then later have to move from to serve their users. The "Slo-penguides" joke has already been made even with the "real" databases :)
indexes. also the fact that it loads half of cpan.
which is really noticable if you dont have a powerful machine.