- From: Ian Hickson <ian@hixie.ch>
- Date: Thu, 26 Nov 2009 02:37:26 +0000 (UTC)
- To: ATSUSHI TAKAYAMA <taka.atsushi@googlemail.com>
- Cc: Joćo Eiras <joaoe@opera.com>, public-webapps@w3.org
On Wed, 25 Nov 2009, ATSUSHI TAKAYAMA wrote: > > (Re-sending because I accidentally replied personally...) > > > Deleting all the data in the database (i.e. dropping all the tables) > > SQLite 3 does not vacuum the database file when you drop a table. > http://www.sqlite.org/lang_droptable.html That seems like an implementation issue. > If you repeat create and drop tables, you will hit the database file > size limit after possibly a long time. If this occurred only on a client > side (i.e. not in the test environment), web developers wouldn't know > that an error is occurring. > > Therefore, it would be nice to have a method to tell how much size the > database is using. I don't think that such a number would make much sense. Different implementations could have radically different space usage for the same data. If the database implementation is inefficient, that's an implementation issue, not a Web application issue. -- Ian Hickson U+1047E )\._.,--....,'``. fL http://ln.hixie.ch/ U+263A /, _.. \ _\ ;`._ ,. Things that are impossible just take longer. `._.-(,_..'--(,_..'`-.;.'
Received on Thursday, 26 November 2009 02:38:00 UTC