miccolis/projectmill — Issue #5: Add '--optimize-sqlite' command
Author: miccolis
Created: 2011-12-23 15:47:16+00:00
State: open

When rendering maps based on very complex sqlite queries performance can tank. It's reasonable to materialize sqlite queries as fresh databases to improve rendering speed. To do this we'd need to:

* Add a `optimize-sqlite` command that would depend on projects being milled
* detected sqlite datasources in project definitions with "complex" queries
* Create a new `materialized-DBNAME.sqlite` database
* Run the complex query, and write the results into the new database.
* Replace the complex query in the project definition with a simple tablename.