On Fri, Aug 14, 2009 at 9:24 AM, Dmitri Priimak<prii...@stanford.edu> wrote: > Hi. > > I have a database with few simple tables. Database is updated regularly > and than distributed to the clients, which only use it for reading. So, > concurrency is not an issue. But the database is already quite large. > The file is about 2.6GB and one table has about 1,800,000 rows > and another one is even larger. Counting all rows in all tables it has > about 5 million rows. In a few year it will grow to about 80 million rows. > So, do you think that SQLite can scale to that level? >
Dunno, but why don't you test it and find out? It would be trivial to write a program that inserts 80 million rows in a db, and then test it... only you know your data. Just looking at the number of rows doesn't tell anything as a table could be a simple table with one column, or a monster with 80 million columns. Indexes could double/triple the size of the raw database. Another thing to think about -- with 1.8 mil rows the sqlite file is 2.6 GB. With 80 mil rows, it would be circa 115 GB. You say the file is "distributed to the clients." I have no idea how you "distribute" (whatever that means) a 2.6 GB file to clients, but, do you really intend to "distribute" a 115 GB file to your clients? A lot of these prospective/predictive questions can usually be answered with a little bit of testing. Do test and share your findings with everyone. Good luck. > -- > Dmitri Priimak > > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > -- Puneet Kishor http://www.punkish.org Carbon Model http://carbonmodel.org Charter Member, Open Source Geospatial Foundation http://www.osgeo.org Science Commons Fellow, http://sciencecommons.org/about/whoweare/kishor Nelson Institute, UW-Madison http://www.nelson.wisc.edu ----------------------------------------------------------------------- Assertions are politics; backing up assertions with evidence is science ======================================================================= Sent from Madison, WI, United States _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
