> I have a need to store large volumes of data (~5-10G) in SQLite > database. The data which I am storing is organized hierarchically. The > schema for my database has foreign-key constraints, the tables are > interrelated. My questions: > > - How can I organize the entire database into multiple files? > > - How do manage such huge databases with SQLite > > > > I am looking for suggestions/advice on how to organize large volumes of > data. Please help.
We usually break the data into subsets and place them into different tables or databases. One per fiscal year, geographic region, etc. We seldom needed reporting over the full data set but it was still possible to do that way.
