On 14 May 2014, at 8:56am, Kleiner Werner wrote: > A collegue has strange behavior with a sqlite database. > The original DB is about 13 MB. > After storing 40 entries in a table the disk space is double and about 26 MB.
I assume from fact that you're concerned about this that the data you're inserting is not big: it doesn't contain any big BLOBs or long strings. Please download a copy of the SQLite shell tool from the SQLite download page and try to duplicate your fault in that application. If you get the same error from trying to do the same INSERTs and SELECT then it may be a bug in SQLite. If not, the bug is probably in the C# code. Make sure that your code checks the result codes from /all/ calls to the SQlite API, not just the SELECT that is presenting the error but also each INSERT and every other API call. > But is it possible to check the database or check why the size is so much > bigger? You should be able to find out which INSERT causes the problem by doing PRAGMA page_count <http://www.sqlite.org/pragma.html#pragma_page_count> after each insert and seeing which INSERT increases the page count a lot. If you do one INSERT and the page count increases by more than five, there's probably something weird going on. Simon. _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
