RSSAmplifier

Jim Kalafut · Feb 14, 2024

Taking an SQL query from 2s to 4ms

0
Sign in to vote or save

This page cannot be shown here. You can still read it on the original site — the toolbar below keeps your place in the directory.

I don’t write much SQL and I rarely have to do performance optimization since systems are so fast relative to my data sizes. But I have a homegrown logging system that using SQLite files in the hundreds of MBs that started slowing down noticeably on queries. This wasn’t a big deal for usage, but it bugged me as to why things were slower so I went digging into the offending query:

Read on /posts/taking-an-sql-query-from-2s-to-4ms/

Comments

Nothing yet. Say the first thing.

    Sign in to join the conversation.