A good alternative to the articles page would be an rss feed with the new releases. I suppose many users would use that to get informed about new releases and that would mean less stress to the server from the articles page.

[sdawson]

A good alternative to the articles page would be an rss feed with the new releases. I suppose many users would use that to get informed about new releases and that would mean less stress to the server from the articles page.

We have one of those 'syndication' up the top... however this pulls and sorts large amount of information in the same way, so has also been disabled for now.

Does not work yet today cannot see the Articles Page even today. When it will be back I am really missing it. The other pages do not give a good picture of the products like this one.

Waiting for the upgrade to complete

There seems to be a restore problem.

viewtopic.php?f=66&t=30023

[sdawson]

Articles an dRSS back online as we have our SQL server back. Hopefully it won't be for a limited time, however if CPU usage slows down the site, I will have to tweak it again.

[sdawson]

Sorry, disabled again, have to rewrite to stop huge CPU usage.

I would suggest that you use some pre-caching. In plain English:

Create it as a topic in some (secret) forum. Then write a script to be run once an hour or something, that will update the topic. I have done such things for certain projects. If you wish more guidelines just tell me.

[sdawson]

I would suggest that you use some pre-caching. In plain English:

Create it as a topic in some (secret) forum. Then write a script to be run once an hour or something, that will update the topic. I have done such things for certain projects. If you wish more guidelines just tell me.

We want real time articles, we could cache alot, but that makes the site not as effective, other large forums cache their search and update it every 30 minutes, this also makes it unavailable for about 5 minutes, but you can't always get what you're looking for.

I will take this into consideration however. Thanks.

hm example you can make new releases rss and add it to feedburner. so all will use trafic from google service, not from yours. it will be fast and etc.

[sdawson]

hm example you can make new releases rss and add it to feedburner. so all will use trafic from google service, not from yours. it will be fast and etc.

It's not the traffic that is a problem, we have plenty of that. It's the fact there are currently 146,000 posts. When you go into the articles page, it scans every single post to find the latest 12. That's alot of scanning, for a very small result. I need to tweak it to make the search way more specific, then hopefully it will only scan 20,000 or so to get the result.

This is my second priority after updating the forum and server security.

[sdawson]

Articles re-enabled to gather some real time data on query times. RSS remains disabled due to using a higher server load overall.

Please use articles, but if you notice the site going slow, refrain from using it. I will probably disable it once I have the info I need for fixing.

sdawson:>
I understand what traffic is not problem. I suggested feedburner service (for example) to save resourses. What's means only service robot will work with this "secret" rss link.
Others will use feed from service and not use your resources.

Btw it's will work like cashing mechanizm

[sdawson]

The RSS script is just badly written, it pulls to much information, I am going to fix this the same way I did with the articles and rewrite parts of it.

[sdawson]

RSS is back, SQL queries optimized with joins.