I'm hoping somebody here can give me some advice with this, but here goes.

I've got a jokes and humor website which I'm in the process of porting it over to a MySQL database. I'd like to include a feature whereby my users can rate the jokes and the ratings would be averaged out and displayed.

Now, my problem is that it sounds, to me at least, that this approach would be rather server taxing. I'd have to store every rating entered and average them out every time someone wanted to see the average rating.

Anybody have any other thoughts about how I could do this? I know this sort of thing has been done before, so if anybody has any thoughts, I'd really appreciate it.

Thanks a lot!