fatalmind · HackerTrans

Submissions

Codd’s Relational Vision – Has NoSQL Come Full Circle?

opensourceconnections.com

1 pointsby fatalmind13 anni fa0 comments

The two top performance problems caused by ORM tools

use-the-index-luke.com

1 pointsby fatalmind13 anni fa0 comments

MongoDB is to NoSQL like MySQL to SQL — in the most harmful way

use-the-index-luke.com

1 pointsby fatalmind13 anni fa-1 comments

Myth: Select * is Bad

use-the-index-luke.com

87 pointsby fatalmind13 anni fa67 comments

What every developer should know about SQL performance

use-the-index-luke.com

1 pointsby fatalmind13 anni fa0 comments

Use The Index, Luke: SQL performance guide now with online examples on SQLFiddle

use-the-index-luke.com

2 pointsby fatalmind13 anni fa0 comments

About SQL Query Hints: Not all hints are born equally

use-the-index-luke.com

1 pointsby fatalmind13 anni fa0 comments

There are only two hard problems in web design: Internet Explorer and Fonts.

twitter.com

2 pointsby fatalmind13 anni fa0 comments

Indexes: The neglected performance all-rounder

use-the-index-luke.com

2 pointsby fatalmind13 anni fa0 comments

Afraid of SSD?

use-the-index-luke.com

1 pointsby fatalmind13 anni fa1 comments

A URL to toss at your SQL devs

use-the-index-luke.com

1 pointsby fatalmind13 anni fa0 comments

The two top performance problems caused by ORM tools

use-the-index-luke.com

5 pointsby fatalmind13 anni fa1 comments

The second power of SQL indexes: Clustering Data

use-the-index-luke.com

3 pointsby fatalmind13 anni fa0 comments

Response Time, Throughput and Horizontal Scalability

use-the-index-luke.com

2 pointsby fatalmind13 anni fa0 comments

Database indexing is a development task—it needs the same care as schema design

use-the-index-luke.com

7 pointsby fatalmind13 anni fa0 comments

FOSDEM Impressions

use-the-index-luke.com

1 pointsby fatalmind13 anni fa0 comments

SQL Indexing and Tuning e-Book

use-the-index-luke.com

130 pointsby fatalmind14 anni fa11 comments

Expert, competent, or greenhorn? Test your SQL performance skills in 3 minutes

use-the-index-luke.com

1 pointsby fatalmind14 anni fa0 comments

Adding hardware won't fix response time problems.

use-the-index-luke.com

1 pointsby fatalmind14 anni fa0 comments

Indexing many columns individually won't give you best database performance

use-the-index-luke.com

1 pointsby fatalmind14 anni fa0 comments

comments

fatalmind

11 anni fadiscuss

I've given this talk on Saturday in Moscow again and it was video taped there. Organizers told me they'll publish the English original as well as the Russian voice over version. I'm keen for the second one ;)

I keep you posted.

fatalmind

11 anni fadiscuss

X-comment so you get it too:

Quoting from http://Use-The-Index-Luke.com/ (the main page):

Use The Index, Luke is the free web-edition of SQL Performance Explained. If you like this site, consider getting the book. Also have a look at the shop for other cool stuff that supports this site.

http://use-the-index-luke.com/shop

fatalmind

11 anni fadiscuss

Quoting from http://Use-The-Index-Luke.com/ (the main page):

Use The Index, Luke is the free web-edition of SQL Performance Explained. If you like this site, consider getting the book. Also have a look at the shop for other cool stuff that supports this site.

http://use-the-index-luke.com/shop

fatalmind

13 anni fadiscuss

That 100GB+ guide has re-appeared at a new URL:

  http://blog.mongodb.org/post/62899600960/scaling-advice-from-mongohq

fatalmind

13 anni fadiscuss

The MsSQL locking problems is just because snapshot isolation is disabled per default: http://use-the-index-luke.com/blog/2011-06-24/dear-database-...

fatalmind

13 anni fadiscuss

Seems like. That's also what this comment on Reddit says:

http://www.reddit.com/r/programming/comments/1niheb/mongodb_...

fatalmind

13 anni fadiscuss

here you go: http://use-the-index-luke.com/sql/join/hash-join-partial-obj...

It's really a PIA.

Recently, I've learned about http://jooq.org/ — not having checked in detail yet, it might be easier there.

fatalmind

14 anni fadiscuss

Other formats (PDF and paperback) are available on a commercial basis:

http://sql-performance-explained.com/

fatalmind

14 anni fadiscuss

Besides your points, we must also consider that MySQL does neither support hash joins nor sort/merge join. MySQL it just not very good at joining.

Nevertheless, a MySQL join should never be slower than the N+1 select approach.

fatalmind

14 anni fadiscuss

Not sure if this is really useful for anybody, but there is a single page version:

http://use-the-index-luke.com/book/export/html/12