I don't know of any direct comparisons between the two processors you mentioned, but you can compare Xeons with identical clocks but varying cache complements here:
I know a guy who exclusively runs Xeons. He has used both the 1MB and 512K processors and claims he notices significant gains with the extra cache memory.