Re: [sqlite] One or many db and vacuum (Improving speed)

2004-07-28 Thread Christian Smith
On Wed, 28 Jul 2004, Rubens Jr. wrote: >Hi ! > >Suppose one database with 4 tables : S1, B1, B2 and B3, where S1 (small >1) has < 100 records, and B1, B2, and B3 (big tables) has > 100,000 >records each. Them entire database has +- 400 MegaBytes. These records >are inserted in ramdom order : S1,

[sqlite] One or many db and vacuum (Improving speed)

2004-07-28 Thread Rubens Jr.
Hi ! Suppose one database with 4 tables : S1, B1, B2 and B3, where S1 (small 1) has < 100 records, and B1, B2, and B3 (big tables) has > 100,000 records each. Them entire database has +- 400 MegaBytes. These records are inserted in ramdom order : S1, B1, B1, B1, B3, B2, B1, B1 ... etc, so I think