NPL have had some good success with this, Owen says it feels like a 1000% improvement in the circulations when all the opac catalog searching is being done on a slave database. I might talk to them about writing up a bit of a How-to. For big libraries it definitely is the way to go. (It has the added benefit of doing realtime back ups too).
Kōrerorero 