Am 22.01.2010 um 15:01 schrieb Michael Thomason: > The only problem is that the table is very large. If I list out the > contents of the table in a text file, it is one-third the size of the > database. So, if the text file is 12 MB, the database is 32 MB.
You may also want to check the encoding of your database: UTF-8 storage may be more efficient, especially when you're expecting to have mostly English words (or words in a language using roman characters). If your database uses UTF-16 encoding, this essentially doubles the storage space needed for those languages. You can use "pragma encoding" to query and set the string encoding in your database (see <http://www.sqlite.org/pragma.html#pragma_encoding>) </jum> _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
