How do you cache third party rss feeds?

[vccubed]

I started using feeds from Google, some TV stations, etc. for fill in on my site by topic... usually adding 3 or 4 fresh stories to the bottom of each page. The stories change anywhere from daily to weekly, I don't need to pull the .xml file every single time and worse than that I'm actually pulling two different .xml files 3 times each for every page a person visits. (once for the user and two more times for GoogleBot to come through looking at adsense.)

I am having problems being banned and/or timing out with the news servers which I don't blame them for, we are a high traffic site.

Any suggestions? Right now I'm using a simple .asp script to display .xml to html

[mack]

I think the best thing you can do is write the feeds to a database then retreive from the database each time you want to display content from the feeds.

I have done this in the past using php/mysql I had a table for feeds and a table for articles. I can then write code to sort or search the articles.

Mack.