Lex Fridman

Rank 24 of 47

Score 60

@levelsio This is a good question and a good idea. A database should give suggestions to it's human designer on how to optimize it based on real-world usage.

7/29/2024, 7:43:44 PM

In reply to:

@levelsio

163d

Why is there no app that runs on your server and checks your slowest SQLite queries and automatically adds indexes?

Why is it not part of SQLite?

I keep having to find slow queries myself and then add indexes

Seems obvious this should be automatic?

The statement does not constitute public discourse as it is a technical suggestion in response to a specific question about database optimization. It does not engage with broader public issues, policies, or societal concerns.