![]() |
Why Does my RSS Feed Max Out At 1000? |
Post Reply
|
Page 123> |
| Author | ||
kennywhite
Groupie
Joined: 26 February 2009 Location: Indy Status: Offline Posts: 50 Points: 67 |
Post Options
Quote Reply
Topic: Why Does my RSS Feed Max Out At 1000?Posted: 16 October 2009 at 7:23pm |
|
|
My RSS feed will only display the last 1000 posts on my blog. I've looked through the code multiple times, trying to find the solution. I'm not very savy in ASP, so it wouldn't be surprising if I over looked something simple.
Here is my code for rss.asp.
____
__
Here is the code for rss.xml. It doesn't seem like this page is actually used. Am I wrong there?
__
Thanks for looking!
|
||
![]() |
||
dpyers
Senior Member
Joined: 12 May 2003 Status: Offline Posts: 3912 Points: 3908 |
Post Options
Quote Reply
Posted: 17 October 2009 at 9:34pm |
|
|
Nothing really jumps out at me, but a couple of things I would look at are:
Is the feed complete from a technical standpoint. e.g. Does it start and end properly (responsewrite it - don't depend upon a feed reader). Is the last entry truncated? What is the actual size of the feed (run the feed through http://web-sniffer.net ) There are limits on things. html pages have a size limit of around 100k. Feed consumers usually have a size limit of 512k, 1024k, or in some instances 2048k. Feed producers are often subject to limits imposed by web servers or isp's. If the feed looks to be technically correct, it may be a limit on the number of entries returned by sql. toss some test counter code in to see if sql is only returning 1000 records. If the last record is truncated, it's likely a CDATA limitation or a restriction on the amount of data returned by the query. If there actually are more than 1000 records produced within a validly formatted feed, then it's a problem with whatever is used to consume ot a problem with production limits set by the host/isp that are truncating the feed. |
||
Lead me not into temptation... I know the short cut, follow me. |
||
![]() |
||
kennywhite
Groupie
Joined: 26 February 2009 Location: Indy Status: Offline Posts: 50 Points: 67 |
Post Options
Quote Reply
Posted: 19 October 2009 at 2:38pm |
|
|
The code is correct as far as I can tell, but I am far from an ASP guru.
The feed size is 1.14 MB
The last message is not truncated at all. I don't think it is a file size issue at all, since it is always the most recent 1000 entries. Never any more, never any less. There is about 1500 entries in the database right now.
This is an intranet site running on IIS 6.0 from a Windows Server 2003 box.
I'm not really sure how to check for an error with what sql is returning. Could you possibly throw me some sample code?
Have you personally seen an RSS feed with more than 1000 entries? I've been looking around, but I have not seen any.
Also, do you know of any other easy to configure rss scripts that I could possibly try?
Thanks.
|
||
![]() |
||
WebWiz-Bruce
Admin Group
Web Wiz Developer Joined: 03 September 2001 Location: Poole, England Status: Offline Posts: 22950 Points: 6143 |
Post Options
Quote Reply
Posted: 19 October 2009 at 2:53pm |
|
|
In your WHERE clause you are using b_published = True, it maybe worth checking that this field is set to true in your database for all records.
You have not said what type of database you are using? |
||
![]() |
||
kennywhite
Groupie
Joined: 26 February 2009 Location: Indy Status: Offline Posts: 50 Points: 67 |
Post Options
Quote Reply
Posted: 19 October 2009 at 3:29pm |
|
|
Oh, sorry I forgot that the database connection wasn't shown here. It is an Access database. Each record is published.
|
||
![]() |
||
WebWiz-Bruce
Admin Group
Web Wiz Developer Joined: 03 September 2001 Location: Poole, England Status: Offline Posts: 22950 Points: 6143 |
Post Options
Quote Reply
Posted: 19 October 2009 at 4:10pm |
|
|
I know that Access has loads of limitations, but I don't think there is a maximum amount of returned records.
Try running the SQL query directly in Access and see if it still returns only the first 1,000 entries. |
||
![]() |
||
kennywhite
Groupie
Joined: 26 February 2009 Location: Indy Status: Offline Posts: 50 Points: 67 |
Post Options
Quote Reply
Posted: 19 October 2009 at 6:52pm |
|
|
I ran the query in Access itself and I got back all 1500 results.
|
||
![]() |
||
WebWiz-Bruce
Admin Group
Web Wiz Developer Joined: 03 September 2001 Location: Poole, England Status: Offline Posts: 22950 Points: 6143 |
Post Options
Quote Reply
Posted: 20 October 2009 at 10:15am |
|
|
I am at a loss then, maybe there is a 1,000 limit in web browsers of the number of results they will show in an RSS Feed.
Maybe try ATOM instead of RSS and see if that makes a difference. I've never seen an RSS Feed with more than around 20 entries, otherwise it is allot for someone to look through. |
||
![]() |
||
Post Reply
|
Page 123> |
| Forum Jump | Forum Permissions ![]() You cannot post new topics in this forum You cannot reply to topics in this forum You cannot delete your posts in this forum You cannot edit your posts in this forum You cannot create polls in this forum You cannot vote in polls in this forum |