top of page
  • Writer's picturekyle Hailey

Stephan Faroult’s Videos

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.

8 views0 comments

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: http://www.adellera.it/blog/2009/06/07/optimizing-sql-statements-with-xpla

Comments


bottom of page