Hello Daniel,
Daniel Franke wrote:
Was sqlite designed for those numbers? The docs state that sqlite
supports "databases up to 2 terabytes in size". OTOH, "supports" is
not the same as "works-well-with"?! Any suggestions whether my
descision to use sqlite was appropiate for this table design?
http://www.sqlite.org/faq.html#q10
From this page...
A database is limited in size to 2 tibibytes (241 bytes). That is a
theoretical limitation. In practice, you should try to keep your SQLite
databases below 100 gigabytes to avoid performance problems. If you need
to store 100 gigabytes or more in a database, consider using an
enterprise database engine which is designed for that purpose.
Best Regards,
Kervin
