On Tue, Dec 7, 2010 at 6:57 PM, Laszlo Nemeth <lnem...@cs.bilgi.edu.tr>wrote:
> Hi, > > Question: is it possible to recompile sqlite to force the > representation of integers to be 4 bytes, and that of floats to be > also 4 bytes. I would like to have no observable change in the > behaviour of sqlite. > > Since integers are effectively packed in sqlite and I suppose you can not map you tick to rowid (I guessed it from the name), the only possible improvement could be floats. You could borrow this idea: http://stackoverflow.com/questions/2775854/map-a-32-bit-float-to-a-32-bit-integerto map it in your reading/writing code to save space for floats. In worst case every 8 bytes float will be 4(5)-byte integer (5 possible due to the internal packed format of sqlite), so maybe you will save 10-15 bytes per record (I added also indexes) Max Vlasov _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
