-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Francisc Romano wrote: > how big databases SQLite can take, please?
Someone told me recently they have 37GB and 66 million rows in their data set. Another user is using the virtual table functionality together with synthetic indices to optimise working with large amounts of 3D data. Quite simply the best thing to do is to generate test data that is representative of what you want to do and the kind of queries you want to execute. Generate your test data and queries as a text file and feed it to the SQLite shell. Roger -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.9 (GNU/Linux) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org iEYEARECAAYFAkrGPmwACgkQmOOfHg372QRY4wCeLYdh9or2DHdT+/iJ3OO6pGap LawAoNDryZiYyd/UZ/ljqRgC/5bwOmf8 =Dthc -----END PGP SIGNATURE----- _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users