Support Forum

Advanced Search
Forum Scope


Match



Forum Options



Minimum search word length is 3 characters - maximum search word length is 84 characters
general-topic
RSS creates long and slow query errors
Avatar
Yellow Swordfish
Glinton, England
SP Master
sp_UserOfflineSmall Offline
Dec 2, 2014 - 12:14 pm

We are slowly in the process of reorganising the website and this was to be added when that goes public. Sorry about that.

For now you can download it from here

Do make a DB backup before you use it...!

andy-signature.png
YELLOW
SWORDFISH
Avatar
kvr28
Member
Free Members
sp_UserOfflineSmall Offline
Dec 8, 2014 - 4:03 pm

question, is there anyway to disable the all rss? that seems to be creating the query issues, if I use either of my two groups rss feed, there is no issue

Avatar
Mr Papa
Simi Valley, CA
SP Master
Free Members
sp_UserOfflineSmall Offline
Dec 8, 2014 - 9:51 pm

keep in mind that rss stuff doesnt generate any queries on less the link/button is clicked on and the rss feed is displayed...

you can turn off all rss feeds on forum - forums - global rss settings...

additionally you can individually remove forum feeds by editing each forum...

if you want to disable just the all rss feed, simply remove the button from your group view template page of you sp theme...  remember, no queries until its loaded...

Avatar
kvr28
Member
Free Members
sp_UserOfflineSmall Offline
Dec 8, 2014 - 10:51 pm

I've done that, but I have people that had already subscribed to the all rss, so the queries are being generated through whatever feed readers they are using

Avatar
Mr Papa
Simi Valley, CA
SP Master
Free Members
sp_UserOfflineSmall Offline
Dec 8, 2014 - 11:04 pm

well, if you disable the feed, then you mightcause them to get endless errors in the feeds...

but guess you could try something like:

add_filter('sph_rss_where', function() {return '0=1';});

which should basically make the query short circuit and return no results...

Avatar
kvr28
Member
Free Members
sp_UserOfflineSmall Offline
Dec 9, 2014 - 7:59 am

would that go into the spfunction

Avatar
Yellow Swordfish
Glinton, England
SP Master
sp_UserOfflineSmall Offline
Dec 9, 2014 - 9:17 am

I believe so... try it there first anyway. Meanwhile I am going to work out how that filter of Steve's works!

andy-signature.png
YELLOW
SWORDFISH
Avatar
kvr28
Member
Free Members
sp_UserOfflineSmall Offline
Dec 9, 2014 - 9:35 am

it creates this error and kills my staging server

Parse error: syntax error, unexpected '=' in /wp-content/sp-resources/forum-themes/default/templates/spFunctions.php on line 31

Avatar
kvr28
Member
Free Members
sp_UserOfflineSmall Offline
Dec 9, 2014 - 10:09 am

what is the difference on how the all rss and the group rss queries? I did a test and moved all forums to the first group and deleted the second group on the staging server, if I use the all rss, long query error still, if I use the group rss no error, but it's all the exact same feed at this point

Avatar
Yellow Swordfish
Glinton, England
SP Master
sp_UserOfflineSmall Offline
Dec 9, 2014 - 10:21 am

First on the matter of the filter, then if you copied and pasted it then it would be corrupt. Steve didn't use the syntax highlighter and those quote marks are no good for program code. So if that is the problem then please remove it and type it in manually...

On the query front then I am as as unsure now as the first day you reported this. All the RSS queries are based upon exactly the same query construct with only a change in the WHERE clause.

The 'long' part of the query I now understand is an irrelevance as, I assume, that still refers to the length of the query text and I am already on record as having no idea why anyone would monitor that. In fact doing just that lengthens the procedure (in time) as the error log needs to be written out which all takes up valuable time of course.

On the 'slow' part then I am truly stumped. As you notice yourself the difference between the 'All' and the other RSS queries is simply the WHERE. In fact, I would almost have expected the 'All' version to be a little faster on balance.

Afraid I really do not know what else to say. It is a complete mystery...

Anyone else have any odeas or anything to add?

andy-signature.png
YELLOW
SWORDFISH
Forum Timezone: Europe/Stockholm
Most Users Ever Online: 1170
Currently Online:
Guest(s) 1
Currently Browsing this Page:
1 Guest(s)
Top Posters:
Mr Papa: 19448
Ike: 2086
Brandon: 864
kvr28: 804
jim: 650
FidoSysop: 577
Conrad_Farlow: 531
fiddlerman: 358
Stefano Prete: 325
Member Stats:
Guest Posters: 619
Members: 17361
Moderators: 0
Admins: 4
Forum Stats:
Groups: 7
Forums: 17
Topics: 10127
Posts: 79625