Andy Hedges’ Tech Blog

So after all my tweaking did my Hibernate effort pay off? YES! Here is some log output of my production server (sounds a lot grander than it is) when I turned on DEBUG for Hibernate management code:


getMostRecentlyPublished took 54 millis
getAllCategories took 3 millis
getPublishedBefore took 19 millis
getPublishedBefore took 4 millis
getMostRecentlyPublished took 85 millis
getAllCategories took 4 millis
getMostRecentlyPublished took 55 millis
getPublishedBefore took 2 millis
getPublishedBefore took 5 millis
getAllCategories took 4 millis
getMostRecentlyPublished took 54 millis
getPublishedBefore took 69 millis
getPublishedBefore took 26 millis
getAllCategories took 3 millis
getMostRecentlyPublished took 86 millis
getPublishedBefore took 4 millis
getPublishedBefore took 4 millis
getAllCategories took 3 millis
getMostRecentlyPublished took 56 millis
getPageOfPublishedArticlesByCategory(Law, 0) took 86 millis
getAllCategories took 3 millis
getMostRecentlyPublished took 57 millis
getPublishedBefore took 59 millis
getPublishedBefore took 37 millis
getAllCategories took 4 millis
getMostRecentlyPublished took 58 millis


I’m amazed quite how fast some of these queries run considering the machine is just a single processor pentium 3 with 384M of RAM. Most of these queries are running 20x faster some are running 100x faster. Load average on the machine has dropped from about 4 to around 0.6 [load average is the number of processes competing for the CPU averaged over a window of time - usually 1 minute, 5 minutes and 15 minutes].

Now if I could get my hands on some proper hardware I could try out some funky JBoss Cache cacheing.

This entry was posted on Thursday, September 29th, 2005 at 8:44 pm and is filed under Java, Open Source. You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.