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. -- Dmitri Priimak _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
