Access: Admin
Total Posts: 1395
Joined: 2006-05-19
When your testing the RSS feed, once you have created a lot of articles, say 50+, it then begins to slow down, correct?
The purpose of an RSS feed is to show the latest number of news articles at a time, not all of them at once. When you subscribe to someone's feed you usually get the latest 10 or so, then when they add a new article, you get that new one and still have the previous 10 because your reader saves them. So there's no need to show all articles to begin with.
The best thing to do would simply be change the amount of articles to show within an RSS feed to 10 instead of 0 (show all).
In the next version I'm going to make the default amount to show 10 instead of 0
Access: Member
Total Posts: 107
Joined: 2009-11-28
No. Thats not it Chris
My test at http://www.homesplaces.co.uk/index1.php is set for ten items in the feed.
Fails validation and mostly timesout.
The moderator at the following coding thread says its HEX CODE appearing in the datastream.
http://www.webmaster-talk.com/php-forum/205556-xml-feed-wont-run-server-coding-2.html
Access: Member
Total Posts: 107
Joined: 2009-11-28
We installed N13 3.6 onto my coders web server and installed my 430 off article database. We noticed that, whilst the RSS feed loads, mySQL specifically is taking up 99% of the partitioned space on the server holding N13.
We think that rss.php opens tables individually for each story which puts a big load on the server. If it does, are the tables getting closed after they are opened ?
Access: Member
Total Posts: 107
Joined: 2009-11-28
Chris
The rss.php script seems to generate temporary tables for each article when froming the XML datastream ?
Script seems to use complex JOINs which require mysql to generate temporary tables so that it can perform the queries.
Ive got a load more info on this. We put fwrites and microtime around the mysql quries in rss.php. These show times taken. We also ran EXPLAIN on the sql queries to show temporary tables are being created.
We wonder if the rss.php needs to work without creating temp tables but we are also, still not entirely sure either.
I can post a load more info about test results if its any use ? Be obliged if you could help us get to the bottom of this strange problem.
Access: Admin
Total Posts: 1395
Joined: 2006-05-19
The script doesn't create any temporary tables. It does however use a fairly complex query to grab the rss data. If temporary tables are being created it's MySQL doing that on its own.
I'm thinking of a new way of doing the RSS feeds. Maybe when you create a new feed, it creates a new 'view' which is sort of like a table. So when the feed is created only then does it run the complex query to create this new view after that all the data will already be in this view so selecting it shouldn't cause a problem at all.
I'll around with this later tonight and report back here if it works.
Latest