5 ms·

SQL Performance Explained, the tuning book for developers, is free today

70 points by MarkusWinand 7y ago

otabdeveloper4 7y ago
> SQL Performance No such thing.
jmkni 7y ago
Thanks!
mgaffney 7y ago
I haven't read the book but it has 5 stars with 19 reviews on Amazon. https://www.amazon.com/Performance-Explained-Everything-Developers-about/dp/3950307826 https://www.amazon.com/Performance-Explained-Everything-Deve...
brudgers 7y ago
I found Use the Index, Luke interesting, but I don't know much SQL. I wonder how this book compares. https://use-the-index-luke.com/ https://use-the-index-luke.com/
- guu 7y ago
  I believe it’s the same content in book form.
  - DannyB2 7y ago
    If it is the same content, then the advantage is that you don't have to give an email address in order to get it for 'free'.
    - _bear 7y ago
      I can read it off-line whilst I'm travelling on the subway/ underground / tube
- chasedehan 7y ago
  Same author of both.
biehl 7y ago
Thanks
ThePadawan 7y ago
I sort of have a beef with the usage of "SQL performance". I know what people mean, but it still irks me. SQL is a declarative query language. It describes the meaning of your query. The execution of the query has performance implications based on the actual RDBMS and the semantics of the query, but you can't improve the performance of your query without altering its meaning, only the performance of its execution. It's like when people describe the performance of Python when they mean the performance of the CPython runtime.
- nomel 7y ago
  > but you can't improve the performance of your query without altering its meaning Could you explain what you mean by "meaning"? From my naive perspective, if different queries give the same results, in all cases, I would consider the "meaning" the same (silly shenanigans aside).
- teh_klev 7y ago
  Pro-DBA here. Not sure why you're being downvoted. I know what you're getting at. Different vendor SQL engines and query optimisers behave differently. There's isn't really a silver bullet for all database engines past the simple and obvious stuff like making sure columns you query most have indexes. Once you've exhausted these tuning options you really need to know your specific database engine's internals.
- pdq 7y ago
  Disagree. For example, indexes are an optimization mechanism which tune the SQL engine for your data set and queries. Creating and planning indexes are outside the scope of your SELECT query, but can give a dramatic performance difference, with the exact same SQL query. See also triggers.

70 points by MarkusWinand 7y ago

otabdeveloper4 7y ago

> SQL Performance No such thing.

jmkni 7y ago

Thanks!

mgaffney 7y ago

I haven't read the book but it has 5 stars with 19 reviews on Amazon. https://www.amazon.com/Performance-Explained-Everything-Developers-about/dp/3950307826 https://www.amazon.com/Performance-Explained-Everything-Deve...

brudgers 7y ago

I found Use the Index, Luke interesting, but I don't know much SQL. I wonder how this book compares. https://use-the-index-luke.com/ https://use-the-index-luke.com/

guu 7y ago
I believe it’s the same content in book form.
- DannyB2 7y ago
  If it is the same content, then the advantage is that you don't have to give an email address in order to get it for 'free'.
  - _bear 7y ago
    I can read it off-line whilst I'm travelling on the subway/ underground / tube
chasedehan 7y ago
Same author of both.

biehl 7y ago

Thanks

ThePadawan 7y ago

I sort of have a beef with the usage of "SQL performance". I know what people mean, but it still irks me. SQL is a declarative query language. It describes the meaning of your query. The execution of the query has performance implications based on the actual RDBMS and the semantics of the query, but you can't improve the performance of your query without altering its meaning, only the performance of its execution. It's like when people describe the performance of Python when they mean the performance of the CPython runtime.

nomel 7y ago
> but you can't improve the performance of your query without altering its meaning Could you explain what you mean by "meaning"? From my naive perspective, if different queries give the same results, in all cases, I would consider the "meaning" the same (silly shenanigans aside).
teh_klev 7y ago
Pro-DBA here. Not sure why you're being downvoted. I know what you're getting at. Different vendor SQL engines and query optimisers behave differently. There's isn't really a silver bullet for all database engines past the simple and obvious stuff like making sure columns you query most have indexes. Once you've exhausted these tuning options you really need to know your specific database engine's internals.
pdq 7y ago
Disagree. For example, indexes are an optimization mechanism which tune the SQL engine for your data set and queries. Creating and planning indexes are outside the scope of your SELECT query, but can give a dramatic performance difference, with the exact same SQL query. See also triggers.