On Fri, 14 Aug 2009 11:00:53 -0700, Dmitri Priimak <prii...@stanford.edu> wrote:
>Kees Nuyt wrote: >> 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. > >It is normalized. I do not keep duplicate of the data anywhere. >Just a lot of data. Ok. -- ( Kees Nuyt ) c[_] _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
