Hello, I'm quite new at sqlite and I need to estimate the size the database I am creating could reach. Basically, estimating for any table how many bytes would be used for an average record. I mainly use INTEGER and REAL values, along with a few TEXT attributes but I couldn't find the number of bytes used to store those datatypes. Anyone could help me on this ? Is there any header or separator I need to take into account ?
By the way, it seems INTEGER are stored on 2 to 8 bytes (from http://theopensourcery.com/sqlitedocs/sqdatatype3.html ). What about 16-byte integers ? Do I have to declare them as REAL to store them ? Many thanks in advance Best regards Nicolas _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
