Certainly a difference Matt, thanks for that.
It just seemed to get slower and slower, although remember the last change you made that gave it steroids!!
Still slow for me, as in click a thread and wait 20 seconds for it to appear, same for any other action.
Been slow for a while now, not said anything as it's usually fixed in a couple of days. About two months ago it was lightning fast - faster than its ever been, just seemed to get gradually slower since.
How long, for comparison, does everyone else have to wait for a thread to appear after clicking the link?
Same here. Except clicking reply just now was relatively nippy. But displaying threads, and the threadlist, is painful. :(
(Posting & bringing up the edit screen both took 'only' about 5 seconds.)
SELECT THREAD.TID, THREAD.FID, THREAD.TITLE, THREAD.LENGTH, THREAD.POLL_FLAG, THREAD.STICKY, THREAD.VIEWCOUNT, USER_THREAD.LAST_READ, USER_THREAD.INTEREST, USER_FOLDER.INTEREST AS FOLDER_INTEREST, UNIX_TIMESTAMP(THREAD.MODIFIED) AS MODIFIED, USER.LOGON, USER.NICKNAME, USER_PEER.PEER_NICKNAME, USER_PEER.RELATIONSHIP FROM DEFAULT_THREAD THREAD LEFT JOIN DEFAULT_USER_THREAD USER_THREAD ON (USER_THREAD.TID = THREAD.TID AND USER_THREAD.UID = 21) LEFT JOIN DEFAULT_USER_FOLDER USER_FOLDER ON (USER_FOLDER.FID = THREAD.FID AND USER_FOLDER.UID = 21) LEFT JOIN USER USER ON (USER.UID = THREAD.BY_UID) LEFT JOIN DEFAULT_USER_PEER USER_PEER ON (USER_PEER.UID = 21 AND USER_PEER.PEER_UID = THREAD.BY_UID) WHERE THREAD.FID IN (1,2,3,4,5,6,7,8,9,11,12,13,14,16,20,22,23,24) AND ((USER_PEER.RELATIONSHIP & 8) = 0 OR USER_PEER.RELATIONSHIP IS NULL) AND ((USER_PEER.RELATIONSHIP & 2) = 0 OR USER_PEER.RELATIONSHIP IS NULL OR THREAD.LENGTH > 1) AND (USER_THREAD.INTEREST IS NULL OR USER_THREAD.INTEREST > -1) AND (USER_FOLDER.INTEREST IS NULL OR USER_FOLDER.INTEREST > -1) AND THREAD.LENGTH > 0 ORDER BY THREAD.STICKY DESC, THREAD.MODIFIED DESC LIMIT 0, 50;
In D:\web\project beehive\beehiveforum: "C:\Program Files\TortoiseCVS\cvs.exe" "-q" "checkout" "-P" "beehiveforum" CVSROOT=:ext:benlumley@beehiveforum.cvs.sourceforge.net:/cvsroot/beehiveforum cvs.exe [checkout aborted]: end of file from server (consult above messages if any) Error, CVS operation failed
aha.
that phrase about nails and heads would be appropriate.
had a feeling it'd be something obvious.
ta.
Is something weird happening with character encoding? I'm seeing the usual weird shit instead of accented characters and currency symbols and stuff, like when unicode's broken.
Is this something you're doing to try to get the RSS working? (giggle)