Re: [sqlite] Database file size

2008-11-28 Thread Simon Bulman
PROTECTED] Cc: 'General Discussion of SQLite Database' Subject: Re: [sqlite] Database file size Am 28.11.2008 um 13:37 schrieb Simon Bulman: > Ahhh, sorry, I wrongly calculated the number of rows in table 2. It > actually > has 29581 rows. Still surprised at the 7x size increase but perhap

Re: [sqlite] Database file size

2008-11-28 Thread Simon Bulman
] Sent: 28 November 2008 08:38 To: [EMAIL PROTECTED] Cc: General Discussion of SQLite Database Subject: Re: [sqlite] Database file size Am 28.11.2008 um 09:20 schrieb Simon Bulman: > Hi Jens, > > Thanks for your input. UTF-8 did not make a difference. I expected > that > SQ

Re: [sqlite] Database file size

2008-11-28 Thread Simon Bulman
schrieb Simon Bulman: > I have been playing around with SQLite to use as an alternative to > one of > our proprietary file formats used to read large amounts of data. Our > proprietary format performs very badly i.e. takes a long time to > load some > data; as expected SQLite

[sqlite] Database file size

2008-11-27 Thread Simon Bulman
the footprint of the db file? Many thanks, Simon -- Simon Bulman Petrel Reservoir Engineering Architect Schlumberger Lambourn Court, Wyndyke Furlong, Abingdon Business Park, Abingdon, Oxfordshire, OX14 1UJ, UK Tel: +44 (0)1235 543 401 Registered Name: Schlumberger Oilfield UK PLC