For the best experience on desktop, install the
Chrome extension
to track your reading on news.ycombinator.com
×
Hacker News
new
|
past
|
comments
|
ask
|
show
|
jobs
|
submit
|
history
|
fatalmind's submissions
register
1.
Myth: Select * is Bad
(
use-the-index-luke.com
)
87 points
by
fatalmind
on Aug 25, 2013
|
past
|
67 comments
2.
What every developer should know about SQL performance
(
use-the-index-luke.com
)
1 point
by
fatalmind
on Aug 16, 2013
|
past
3.
Use The Index, Luke: SQL performance guide now with online examples on SQLFiddle
(
use-the-index-luke.com
)
2 points
by
fatalmind
on Aug 13, 2013
|
past
4.
About SQL Query Hints: Not all hints are born equally
(
use-the-index-luke.com
)
1 point
by
fatalmind
on July 26, 2013
|
past
5.
There are only two hard problems in web design: Internet Explorer and Fonts.
(
twitter.com/markuswinand
)
2 points
by
fatalmind
on July 18, 2013
|
past
6.
Indexes: The neglected performance all-rounder
(
use-the-index-luke.com
)
2 points
by
fatalmind
on July 11, 2013
|
past
7.
Afraid of SSD?
(
use-the-index-luke.com
)
1 point
by
fatalmind
on July 2, 2013
|
past
|
1 comment
8.
A URL to toss at your SQL devs
(
use-the-index-luke.com
)
1 point
by
fatalmind
on April 25, 2013
|
past
9.
The two top performance problems caused by ORM tools
(
use-the-index-luke.com
)
5 points
by
fatalmind
on April 23, 2013
|
past
|
1 comment
10.
The second power of SQL indexes: Clustering Data
(
use-the-index-luke.com
)
3 points
by
fatalmind
on April 22, 2013
|
past
11.
Response Time, Throughput and Horizontal Scalability
(
use-the-index-luke.com
)
2 points
by
fatalmind
on April 21, 2013
|
past
12.
Database indexing is a development task—it needs the same care as schema design
(
use-the-index-luke.com
)
7 points
by
fatalmind
on April 20, 2013
|
past
13.
FOSDEM Impressions
(
use-the-index-luke.com
)
1 point
by
fatalmind
on Feb 5, 2013
|
past
14.
SQL Indexing and Tuning e-Book
(
use-the-index-luke.com
)
130 points
by
fatalmind
on Dec 16, 2012
|
past
|
11 comments
15.
Expert, competent, or greenhorn? Test your SQL performance skills in 3 minutes
(
use-the-index-luke.com
)
1 point
by
fatalmind
on Dec 14, 2012
|
past
16.
Adding hardware won't fix response time problems.
(
use-the-index-luke.com
)
1 point
by
fatalmind
on Oct 3, 2012
|
past
17.
Indexing many columns individually won't give you best database performance
(
use-the-index-luke.com
)
1 point
by
fatalmind
on Sept 24, 2012
|
past
18.
A quiz that teaches you how to avoid the most common SQL performance issues
(
use-the-index-luke.com
)
1 point
by
fatalmind
on Aug 16, 2012
|
past
19.
Get to know your ORM and take control of joins.
(
use-the-index-luke.com
)
40 points
by
fatalmind
on July 18, 2012
|
past
|
23 comments
20.
Stop worrying and learn to use the index
(
use-the-index-luke.com
)
2 points
by
fatalmind
on July 4, 2012
|
past
21.
A visual explanation why SQL's LIKE is slow
(
use-the-index-luke.com
)
1 point
by
fatalmind
on June 24, 2012
|
past
22.
Performance impact of sloppy indexing in SQL databases
(
use-the-index-luke.com
)
1 point
by
fatalmind
on June 19, 2012
|
past
23.
Table of Contents: Everything developers need to know about SQL performance
(
use-the-index-luke.com
)
1 point
by
fatalmind
on May 18, 2012
|
past
24.
Not using SQL bind parameters is like recompiling a program every time.
(
use-the-index-luke.com
)
1 point
by
fatalmind
on May 15, 2012
|
past
25.
Database scalability is not only about scale-up, scale-out and hardware...
(
use-the-index-luke.com
)
1 point
by
fatalmind
on April 28, 2012
|
past
26.
NULL in the Oracle Database — Is it special, or strange, or just wrong?
(
use-the-index-luke.com
)
2 points
by
fatalmind
on April 21, 2012
|
past
|
1 comment
27.
Reading Database Execution Plans (MySQL, PostgreSQL, Oracle, and SQL Server)
(
use-the-index-luke.com
)
1 point
by
fatalmind
on April 17, 2012
|
past
|
1 comment
28.
Several ways to SQL pagination, including performance charts
(
use-the-index-luke.com
)
22 points
by
fatalmind
on March 16, 2012
|
past
|
5 comments
29.
SQL Paging queries using SQL "window functions"
(
use-the-index-luke.com
)
2 points
by
fatalmind
on Feb 10, 2012
|
past
30.
SQL pagination in constant time using the "seek method"
(
use-the-index-luke.com
)
4 points
by
fatalmind
on Feb 2, 2012
|
past
|
1 comment
More
Guidelines
|
FAQ
|
Lists
|
API
|
Security
|
Legal
|
Apply to YC
|
Contact
Search:
×
HN For You
Display Mode
Highlight
Top
Only
Debug mode
Sign Out
API Key:
Connect
Create an account
to get your API key.