Optimizing pysqlite/sqlite3 databases and queries: Part II: Scaling & Splitting (notes/outline for 2009 Nov 9 presentation to TuPLE — edited post-presentation version)



Some References

How Does it Scale?

Some Theory

Different database files may temporarily be treated as part of the same database using SQLite’s ATTACH command. (drawing on whiteboard during my talk)

Some Practical Observations and Test Data

Graph: Creation progress of a single db file containing one table plus indices


The End