Under unreal conditions.
Originally Posted by Chrome
You implied it.
2) I have never told that transactions are synchronizations. SQLite isn't database server.
You're right.. because sqlite is about as useful as a text file.
Test results from SQLite can't be considered as results from database server.
... which don't actually need it. It also resulted in some serious PROBLEMS for firefox, mostly dealt with by now, but still memorable.
SQLite is used in applications like Firefox and Chrome.
No, it isn't how any application should work. NO application is going to be running 25k inserts into a database like that! The results are MEANINGLESS because nobody is EVER going to do that!
Test2 is relevant test of disk performance because this is how every real application should work.
Which clearly identifies a DEFECT in that old version of pgsql.
PgSQL was also much faster in that test with transactions - 28 times. Compare Test1 and Test2.
No it won't... because of those 5-queries, most likely only ONE of them will be an update or insert. The performance of read-only queries is unaffected by synchronization.
Inserting data using 5-query transactions will be approx. 5-times faster than without transactions.