If you're ordering them so the longest emoticons are first then it sounds like it shouldn't matter, good work!

care to share the name of said profiler?

I'll take a look at the threads_any_unread function...

XDebug and WinCacheGrind to examine the profiles it creates.

Just had an hour if it being virtually dead including an error from the server which was:

 

Fatal error: Maximum execution time of 30 seconds exceeded in /var/www/vhosts/tehforum.co.uk/httpdocs/forum/include/emoticons.inc.php on line 103
Call Stack
# Function Location
1 {main}() /var/www/vhosts/tehforum.co.uk/httpdocs/forum/messages.php:0
2 message_display() /var/www/vhosts/tehforum.co.uk/httpdocs/forum/messages.php:386
3 message_split_fiddle() /var/www/vhosts/tehforum.co.uk/httpdocs/forum/include/messages.inc.php:618
4 emoticons->emoticons() /var/www/vhosts/tehforum.co.uk/httpdocs/forum/include/messages.inc.php:477
5 count () /var/www/vhosts/tehforum.co.uk/httpdocs/forum/include/emoticons.inc.php:103

 

Not sure if it's any use, but I thought I'd post it just in case :)

Don't know if you've been tinkering, Matt, but it's been significantly speedier today and tonight.

Same.

Some of the tweaks I've made to BH are in use here now and I've got some more to come as well, but I think it's mostly down to finding a balence between Apache and MySQL.

Well either way, it's roaring along very nicely indeed at the moment. I just clicked "reply" and the reply window took only about second to load! So nice one Matt and all that :)

Aye, it's definitely a hell of a lot better just now. Yay!

I've done that USER_THREAD thing (that Mark was on about) and made unread messages only remember up to a configurable number of seconds away (defaults to 1 year now but can be set to -1 seconds to go back to the old default) so if you want to you can set up a forum to never remember unread threads (0 second cutoff) which while mostly pointless someone might find a use for.

 

Only slight loss of functionality means loosing the [x new of y] bit on threads which haven't been modified since the cutoff and instead they'll display as being fully read. You'll still be able to find threads with posts addressed to yourself easily using the right option and find recent unread threads so I really don't see that as being a problem.

 

Comments?

Thank you Matthew Beale.

Beautifully speedy at present.

It's useable again, which is great. Cheers dude.

{{{{{{Matt}}}}}}

Well done Matt a massive difference to how it had become.

 

Absolutely spot on.

Some trade-offs have to be made and I'll take a nice speedy forum over a small piece of extra functionality which I might find useful once every few years every time :)

Hurrah for doing that thing I was on about, then.

 

Good work, though, seriously. Massive improvement.