Re: [sqlite] limiting database size

I want to put a limit like 10mb then later on e able to change this database limit to 15mb if I want to, is this possible? You could use auto_vacuum (so the data file shrinks when data is deleted) and check the file size so you know when it is "full." l8r Sean

Re: [sqlite] Write performance

I've been inserting data into a table with a non-integer primary key. The data does not come in in an ordered fashion. My thought is that perhaps performance suffers because it needs to rewrite huge chunks of the data file in order to slot the new data into its correct position within the file b

Re: [sqlite] Write performance

SQLite write (insert) performance doesn't seem very good to me so I'm trying to find ways to improve it in my application. I had this idea so I figured I'd run it past you folks who likely better know how the db works under the hood. did you wrap your inserts in a transaction? I don't think

[sqlite] Write performance

SQLite write (insert) performance doesn't seem very good to me so I'm trying to find ways to improve it in my application. I had this idea so I figured I'd run it past you folks who likely better know how the db works under the hood. My thought is that perhaps the write performance suffers

Re: [sqlite] Reads and Writes

After SQLite obtains a read lock it will have to perform at least the following: - check the file header to check for corruption - check for a hot transaction log, and roll back changes if necessary - read the database schema from the sqlite_master table This is the most likely cause of the repet

[sqlite] Reads and Writes

My program has a lot of simple select queries. Most of them are of the "select count() from... " variety. These are very simple queries where there is a single WHERE clause and the columns referenced are either a primary key column or another indexed column. I would expect the database to

[sqlite] Sharing Knowledge - sqlite3_reset()

This is perhaps well known in the community, but I just spent a day banging my head against the wall and figured I'd send out a note so that others who have similar problems may come across it and help them out. :-) It is critically important that sqlite3_reset() be called right after yo