On Fri, 14 Aug 2009 07:24:31 -0700, 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? It will. The other guys gave enough insight on that. But does it really have to get that big? I've seen databases shrink tremendously once properly normalized. -- ( Kees Nuyt ) c[_] _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
