[sqlite] how can i speed up inserts ?

i've got sqlite compiled with visual-studio, with all the default options, didn't touch anything. inserts are just a bit too slow for me, is there a good way to speed this up using some flags ? any other flags that it would be smart to turn on for some better performance ? thanks

[sqlite] 3.3.10 data corruption on updating fts1 string table

inserts work once i update my fts1 table and then select data from it, i get gibberish. anybody seen something like this ?

[sqlite] Unable to close due to unfinalised statements

i have an fts1 query that if i perform it and then close the database, i get the above error. i looked in and it seems like a query usually calls: vm = compile(sql); ret = _sqlite3_step(vm); i noticed that the pointer to the vm is stored in the db struct as well. in this particular query, the

[sqlite] fts1 and word boundary

i have an fts1 table populated with, errr, text. lets say one field has this text "big monster". this sql query: text match 'ter' doesn't return this item. if i do a text match 'monster' i do get this item. does fts1 support this behavior i need ?

[sqlite] retrieve num-rows from a result

just started using sqlite through a c++ wrapper. i need to be able to know how many rows are contained in a result, is this possible ? i've looked through the c api and can find only a 'number of rows affected' when inserting/deleting, nothing about num-rows of a select