[sqlite] Organizing large database into multiple files

[Rajan, Vivek K]

Hello- 

 

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. 

 

Vivek