From The TimeSplitters Wiki

The most damging pistol in Future Perfect ,but that come with a drawback (slow fire rate). The revolver is similar to the Garret Revolver and is found in the mansion series of levels (Mansion of Madness and What Lies Below ) of Future Perfect. The need in the first of the two is pretty much short lived because not much later, you find the shotgun.