Yes, that does help me. Thank you for sharing! -Dan
Rajesh Nair-5 wrote: > > I have a real time program which logs more than 30,000 records, each > record of about 200 bytes, per day and the company in which it has > been installed is working 24/365. I installed the project on 2005 > August and it is working fine till date. It perform some report > generations (4 or 5) every day. The data is dumped to Sqlite database > and I don't know the current size of that database. But the PC is with > just 256 MB RAM and 160 GB hard disk and CPU is 800MHz. It is working > for last 3-4 years without shutting down and without any data crash or > program crash. It is so designed to VACUUM the database on 20th of > each month or the nearest sunday. > The database when I last checked was of size 4 GB and it may be > increased to 6 or 7 GB now. > I have modified the program to split the database on yearly basis long > before, but the company is not ready to accept the modification. > > But still it works fine. Is that enough for you...... > > -- > Regards > Rajesh Nair > ________ > -- View this message in context: http://www.nabble.com/100-million-records-will-be-fine--tp22038526p22120394.html Sent from the SQLite mailing list archive at Nabble.com. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
