An ORDER BY statement improved our query times by 100x
July 24, 2024
#postgresql #reading-list #sql
🔗 An ORDER BY statement improved our query times by 100x
webapp.io
PostgreSQL queries can be sped up by creating the right indices, and making sure that the indices are being used.
It's a tale as old as SQL databases - there's a critical code path being hit many times per second, but its queries are inexplicably slow.
continue reading on webapp.io
⚠️ This post links to an external website. ⚠️
If this post was enjoyable or useful for you, please share it! If you have comments, questions, or feedback, you can email my personal email. To get new posts, subscribe use the RSS feed.