Re: [sqlite] Fastest way to insert lots of data

2009-07-24 Thread Pavel Ivanov
Try to add to your SQLite test these steps: 3.5) Execute statement BEGIN (you can do it via prepared statement). 5.5) Say every 10 000 records execute COMMIT and then BEGIN again. Or if you indeed want to measure maximum write speed then skip this step at all. And your words that pragma

[sqlite] Fastest way to insert lots of data

2009-07-24 Thread Zachary Turner
What kind of performance can I expect to get from sqlite inserting many many rows of blob data into a database? I know this depends on many factors, but I'm a little puzzled because I have written some tests that allow me to test various ways of inserting data and as far as I can tell I've