Announcement

Collapse
No announcement yet.

SQLite 3.15 Reduces CPU Usage, Adds Support For Row Values (Vectors)

Collapse
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • SQLite 3.15 Reduces CPU Usage, Adds Support For Row Values (Vectors)

    Phoronix: SQLite 3.15 Reduces CPU Usage, Adds Support For Row Values (Vectors)

    SQLite 3.15.0 is now available as the latest feature release of this widely-used, embed-able SQL database library...

    http://www.phoronix.com/scan.php?pag...-3.15-Released

  • #2
    Coincidentally today I had an issue with row values comparison in Postgres.

    SELECT (1,null) IS NULL, -- false
    (1,null) IS NOT NULL, -- false
    NOT (1,null) IS NULL; -- true

    IS NOT NULL is only true if all the values in the row value are not null, I've missed more than 70% of the rows in my where clause because of it

    Comment

    Working...
    X