Re: [sqlite] database size (again)

On Tue, Dec 7, 2010 at 6:57 PM, Laszlo Nemeth 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

Re: [sqlite] database size (again)

A lot of the SQLite overhead is going to be in the stuff surrounding your actual data; I'd be surprised if you saved much space by using fixed-size ints vs the varints used by SQLite. You didn't mention about indexes; if you have any, they will take a lot of space because your row size is so

[sqlite] database size (again)

Hi, I have a database (6 in fact) of high-frequency data create table eurusd (tick integer not null, bid float not null, ask float not null); with 80M records currently and growing, freshly inserted, no deletions will ever take place, the schema will never change, and neither of the