Support Forum

sp_Search Search
Advanced Search
Advanced Search
Forum Scope


Match



Forum Options



Minimum search word length is 3 characters - maximum search word length is 84 characters
sp_Search Search
Page: 1Jump to page %PAGE% of this topic 45678Jump to page
plugins-topic
What would cause the recent forum posts widget to not update?
Avatar
kvr28
Member
Free Members
sp_UserOfflineSmall Offline
sp_UserWebsite
Go to Top
Nov 30, 2014 - 11:34 am

alright, thank-you yellow, I just bit the bullet and delved into the scary world of my live database, happy to report it was a success and I did not totally destroy my site!

Avatar
kvr28
Member
Free Members
sp_UserOfflineSmall Offline
sp_UserWebsite
Go to Top
Nov 30, 2014 - 11:37 am

I wonder if the long query issue was because of the two different tables, it was trying to query them both

Avatar
Yellow Swordfish
Glinton, England
SP Master
sp_UserOfflineSmall Offline
Go to Top
Nov 30, 2014 - 11:46 am

No that's not the issue there. That actual data is used in the construction of the query not the execution.

But - as I said above somewhere - all the 'long query' thing is about is the physical text length of the query itself. Nothing to do with its execution or performance. As I also said - it seems 100% pointless and annoying to track something like that which has no relevance to anything!

andy-signature.png
YELLOW
SWORDFISH
Page: 1Jump to page %PAGE% of this topic 45678Jump to page
sp_Feed All RSS
Go to top
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: 17363
Moderators: 0
Admins: 4
Forum Stats:
Groups: 7
Forums: 17
Topics: 10127
Posts: 79625