On Aug 8, 2013, at 3:40 PM, Christopher W. Steenwyk <csteen...@gmail.com> wrote:
> This database is generated once, and then queried and interrogated multiple > times. So I am most concerned with read speed and not with writing or > updating. Ohohoho… in that case… I have some snake oil to sell you, Dear Sir! If your problem domain fits, I would suggest dimensional modeling: http://en.wikipedia.org/wiki/Dimensional_modeling The Kimball variety (ignore the Inmon heresy and associated charlatans): http://en.wikipedia.org/wiki/Ralph_Kimball Specifically a star schema (ignore anything reeking of snow flakes): http://en.wikipedia.org/wiki/Star_schema Follow the Kimball Scriptures to the letter: http://www.amazon.com/The-Data-Warehouse-Toolkit-Dimensional/dp/0471200247 (Until you have enough practical experience to break all the rules as you see fit, once you know better) Free advise… avoid the 'caterpillar syndrome'… a rookie deathtrap featuring an overly fat and wide fact table, with a multitude of teeny-weeny dimensions… http://en.wikipedia.org/wiki/Fact_table http://en.wikipedia.org/wiki/Dimension_table Analyze and correlate what belongs where… there is no silver bullet, but to understand your data first and foremost. May the Truth be with you. Go in peace and be merry. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
