top of page

Stephan Faroult’s Videos

  • Writer: kyle Hailey
    kyle Hailey
  • Jun 1, 2009
  • 1 min read

I love this video on “getting dreadful database performance” by Stephan Faroult.

The video is hilarious and infomative:

He tackles top 5 keys to dreadful peformace

1. EAV “schema” 2:10

2. Unusable indexes 6:00

3. Hard parsing 7:36

4. Unitary processing 10:40

4.5 user functions (instead of join, ex: currency conversion) 12:19

5. views of views 14:46

Conclusion: most developers are young and clueless about database (java programmers?) and code must be refactored by devlopers not by DBAs in production databases, and hopefully with guidance by an experienced (older) expert.

The first topic EAVs was a huge problem at 3 of the last 4 companies I was at, including Oracle’s OEM 10g Grid control, despite solid analysis of pro’s and con’s by John Beresniwisz.

Just emailing Stephan, I found out that his video was inspired by this fun video (though less related to UI or databases):

Identity 2.0

I like this kind of presentation. Fun and informative as well as efficiently re-iterating the important points.

Recent Posts

See All
Alberto Dell’Era’s XPLAN

Check out Alberto Dell’Era’s SQL query analyzer – lots of good info like this compact table of indexes availble on the query:...

 
 
 

Comments


Kyle Hailey

  • Facebook
  • Twitter
  • LinkedIn
  • Instagram

San Franisco, Ca 94131

415-341-3430  (please text initially before calling)

bottom of page