February 21, 2005

Performance improvement results

Follow-up to Garbage collection and Hibernate performance tuning from Kieran's blog

Old version:

  • System home page:71 sql queries
  • Individual blog home page:120 sql queries

New version:

  • System home page: 24 sql queries (15% faster load times…very approximate)
  • Individual blog home page: 73 sql queries (25% faster load times…very approximate)

Turns out the old system homepage was still generating the hot topics and most recent entries, but not actually using them.


- 4 comments by 1 or more people Not publicly viewable

  1. I find it oddly comforting that they were there, sort of, all this time.

    21 Feb 2005, 10:19

  2. Ahhh, happy memories of hot topics? :)

    21 Feb 2005, 10:22

  3. Good old hot topics. If only they were still about somewhere.

    21 Feb 2005, 11:24

  4. In your heart, you know which topics are hot.

    21 Feb 2005, 13:24


Add a comment

You are not allowed to comment on this entry as it has restricted commenting permissions.

February 2005

Mo Tu We Th Fr Sa Su
Jan |  Today  | Mar
   1 2 3 4 5 6
7 8 9 10 11 12 13
14 15 16 17 18 19 20
21 22 23 24 25 26 27
28                  

Tags

Search this blog

Most recent comments

  • One thing that was glossed over is that if you use Spring, there is a filter you can put in your XML… by Mathew Mannion on this entry
  • You are my hero. by Mathew Mannion on this entry
  • And may all your chickens come home to roost – in a nice fluffy organic, non–supermarket farmed kind… by Julie Moreton on this entry
  • Good luck I hope that you enjoy the new job! by on this entry
  • Good luck Kieran. :) by on this entry

Galleries

Not signed in
Sign in

Powered by BlogBuilder
© MMXX