SQLite the only database you will ever need in most cases

Re:SQLite the only database you will ever need in most cases by acuozzo on Thursday February 16, 2023 @10:32AM (#34819965)

I meant hardware caches like L1, L2, and L3 on the CPU.

SQLite is used in some HPC work.

ISO-8601 datetime strings can easily wreck your L1 cache. Instead of filling an eighth of the cache with a 64-bit value, you wind up filling almost half with a 27-character-long string.

[ Parent | on HN ]

Re:SQLite the only database you will ever need in most cases by di456 on Thursday February 16, 2023 @11:25AM (#34820787)

I learned something new, thanks for sharing!

What format works well for hardware caching?

[ Parent | on HN ]

Re:SQLite the only database you will ever need in most cases by acuozzo on Thursday February 16, 2023 @02:20PM (#34824257)

yw :-)

As small as you can tolerate tbh. The game is played by keeping data as small as possible and ensuring that related data has good locality in memory.

The gap between how fast your CPU works and how fast data can be retrieved from RAM is enormous.

[ Parent | on HN ]