Hello, I'm using sqlite in a speed critical application. Data integrity after crashes is not very important as the database can be recreated from scratch in that case.
In my tests, the writing of data with insert commands seemed very slow, despite being wrapped in a transaction. I have tried PRAGMA synchronous=off and also compiled the asynchronous io module in, but that didn't help much. A little profiling revealed that the unixSync function is called somewhere down the callstack of the insert command. And there, full_fsync seems not to take the pragma settings or the async io module into account. I recompiled sqlite with the SQLITE_NO_SYNC definement and had a huge increase in speed. Is this intended behaviour? How does the pragma/async io module fit in, then? Cheers, Benjamin _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
