SQLite 3.16 Released, Uses Less CPU Cycles & Adds Experimental PRAGMA Support

[phoronix]

Phoronix: SQLite 3.16 Released, Uses Less CPU Cycles & Adds Experimental PRAGMA Support

SQLite 3.16.0 was released today and it's quite a feature-packed release for being the first update of 2017...

http://www.phoronix.com/scan.php?page=news_item&px=SQLite-3.16-Released

[rene]

thanks for the pointer, update pushed in T2: http://t2-project.org/packages/sqlite.html

[willmore]

It should be 'fewer CPU cycles'. Fewer is for things your can count. Less is for continuous quantities. Finally an English rule a programmer can understand natively.

[bug77]

It should be 'fewer CPU cycles'. Fewer is for things your can count. Less is for continuous quantities. Finally an English rule a programmer can understand natively.

Pointless post, but I couldn't resist.

[Anvil]

AFAIK, the database of sqlite is rather slow, have they sped that up

[ldo17]

Ah, the world’s most popular DBMS. Odds are you have a copy in your pocket or purse.

[bug77]

AFAIK, the database of sqlite is rather slow, have they sped that up

"Rather slow" is a bit too generic to comment on. I've actually benchmarked Sqlite rather recently. It's faster to read and slower to write than JavaDB.
Also keep in mind that in order to keep size small, Sqlite isn't usually compiled with all features enabled.

[cj.wijtmans]

sqlite is fast enough for small databases that dont have much traffic.