Hibernate queries are slow ! SQL Server's are not my type ? - Here is what you need to know!
" Hibernate is one of most cited culprit for slower queries ! ", though I am kind of victim of this thought for sometime until I "understood" the true wisdom of lame excuses :) http://imgs.xkcd.com/comics/estimation.png Though sometimes this epic comic reflects my mental turbulence during the performance improvement katas... I learned not to go by hunches, but on real hard facts and truths. One interesting problem I found recently pretty annoying me for days (actually months sparingly) was slow query performance of the total application I was working on. Though the problem is itself is pretty basics, but the process of tuning and troubleshooting is what I thought is interesting. To give a background, I was running Hibernate/Java/Spring Stack SQL Server 2008 as my DB (it's out of choice unquestionably) but I don't mind and stick to one technology so opportunity to try new / old things are always good. Here is the graph of the actu