Re: [sqlite] How to calculate the size of my database for n records ?

On 15/04/2009 11:50 PM, Nicolas Gaiffe wrote: > Thank you Igor. > > Does anyone have a clue about estimating the size of a database ? >> 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

Re: [sqlite] How to calculate the size of my database for n records ?

Thank you Igor. Does anyone have a clue about estimating the size of a database ? > 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

Re: [sqlite] How to calculate the size of my database for n records ?

"Nicolas Gaiffe" wrote in message news:a729b91e0904140537p7f97fae0q7f2afcb327e55...@mail.gmail.com > 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 ? SQLite doesn't

[sqlite] How to calculate the size of my database for n records ?

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