Diomidis Spinellis personal blog
How I slashed a SQL query's runtime with two Unix commands
I was trying to run a simple join query on MariaDB (MySQL) and its performance was horrendous. Here’s how I cut down the query’s run time from over 380 hours to under 12 hours by executing part of it with two simple Unix commands.
- Points
- 249
- HN comments
- 83
- Submissions
- 1
- Cited by
- 0 commenters
Databases & DataTools & Productivity2018
On Hacker News
| Submitted | Title on HN | Points | Comments |
|---|---|---|---|
| Aug 5, 2018 | How I slashed a SQL query's runtime with two Unix commands by DSpinellis | 249 | 83 |
