Two words you don't often see together

« Roller 0.9.8-dev... | Main | la Repubblica.it... »

Two words you don't often see together

are FreeRoller and fast.

<a href= "http://freeroller.net/page/nic/20030909#freeroller_net_snappy_and_fast"> Nic: freeroller.net snappy and fast!

That is nice to hear, but will it still be snappy and fast after 24 hours?

<a href= "http://freeroller.net/page/aspinei/20030909#freeroller_finds_cure_to_it"> Aspenei: Someone, oh please !, someone tell me how did FreeRoller became so snappy overnight. If only I'd be able to implement such performance improvements in my customer's apps i'll instantly become their Java Consultant God (TM) or something.

The answer is Roller 0.9.8 which includes better usage of Hibernate, Hibernate/JCS caching, database indices, and numerous small fixes and improvements made over the last couple of months by the Roller team.

Dave Johnson in Roller 10:57AM Sep 09, 2003 Comments [9]
Tags: Roller

Comments:

At 4:11pm central time, I'm getting one of 3 responses while trying to view the "Snappy and Fast" entry: 1-[Takes more than 15 seconds to load the page] 2-[404 - page not found error] 3-[Page loads very snappily] And your calendar on the upper right of the page is over part of the main page (I'm using IE6, WindowsXP).

Posted by Will Gayther on September 09, 2003 at 08:14 PM EDT #

I spoke too soon. I just got a couple of 404s myself. The log says that DBCP is running out of database connections. I think we'll be seeing a restart tonight.

Posted by Dave Johnson on September 09, 2003 at 08:18 PM EDT #

I think I suggested this a while ago: Static Pages! Forget the db for serving pages, serialize the entries out into static html using Velocity and be done. Let Apache handle the volume and Roller do the editing. You can even add in an FTP server option like Blogger, and get some of static pages off the site as well. We're talking a Quartz task to serialize and maybe an evening's effort or your part for integration. :-) -Russ

Posted by Russ on September 09, 2003 at 10:13 PM EDT #

...so wait, you weren't using database indices before? :-) You should try out c3po for database pooling... I was talking with Gavin King online the other night as he was performance testing Hibernate with many threads. With c3po he had no problems. With dbcp it was running out of connections (over 150) when the max active was set to 40. This is a problem, I think :-)

Posted by Jason Carreira on September 09, 2003 at 10:41 PM EDT #

Russ, that is a good suggestion, but I don't think that it is an evening's work. Plus, with the level of caching we are doing, FreeRoller is almost a static site. We are caching pages for 3 hours, RSS feeds for 24 hours, and using an unlimited disk cache.

Jason, we were using a couple of indices, but somebody with actual database expertise looked at the schema and suggested additional indices. On the topic of connection pooling, I'm interested in exploring alternatives to DBCP. It is difficult to configure and the error messages it produces are less than useless.

Posted by Dave Johnson on September 09, 2003 at 11:35 PM EDT #

I've recently started using C3P0 for connection pooling with Hibernate as well, and I'm quite pleased with it. It definitely seems better than DBCP (which, as I understand it, is basically being rewritten for its next release). C3P0 is trivial to set up as well.

Posted by Rafe on September 10, 2003 at 01:42 PM EDT #

I discovered the hard way that the current releases of DBCP kinda sucks - there's some thread-safety problems lurking in there somewhere that cause its connection count to get messed up. The behaviour I was seeing is that it would report negative counts in the pool, so would happily a) go over its max limit and b) never reap certain connections. I switched to bitmechanic's JDBC pool, and have been much, much, much happier.

Posted by Bill Stilwell on September 15, 2003 at 11:04 PM EDT #

Great comments guys. Peter FDA

Posted by Peter on November 11, 2003 at 06:21 AM EST #

One nitpicky request: Links are some of the most noticable text on a page

Posted by bali on December 13, 2003 at 05:32 PM EST #

Welcome

This is just one entry in the weblog Blogging Roller. You may want to visit the main page of the weblog

Related entries

Below are the most recent entries in the category Roller, some may be related to this entry.