Advice please!

[Sulman]

Hi All,

 

I'm looking for some advice:

 

What do you think would be the best way to achieve this:

I have a script that grabs a load of RSS feeds etc (using lastRSS). What I want to be able to do is to cherry pick certain feeds and put them in to a DB (this is all working fine). But now when I refresh the page those feeds are still showing. My problem is once I have chosen some feeds how would I go about ensuring those feeds are not shown again (whether they are feeds that I have selected or feeds that I have ignored).

 

Any clues?

 

Thanks

[dzelenika]

You should chek if "pubDate" "lastBuildDate" or some other unique field of grabbed RSS is not in your database of selected, ignoed or ignored feeds.

 

[Sulman]

Thanks dzelenika for the reply.

 

That would mean that I am querying the DB (potentially) thousands of times per page loads (if I have 1000+ unread feeds).

 

Currently I pull every single feed into a table with the link as the PK. This way it will only import feeds that are not already in there (due to the unique PK constraint).

 

Then I choose the feeds I want and export them into a new table. I then set the original table status flag to 1.

 

Finally I list all feeds for approval from the first table that have a status of 0.

This should ensure I only see feeds that I haven't seen already.

 

The only drawback with this is that the tables could get very big very quickly so I'll have a cron running every week or so that deletes anything past a certain date.

 

Thanks