Finding the forum a bit slow? This can help...

[Administrator]

Whilst logged in go the main page http://www.eastdulwichforum.co.uk/forum/index.php?4 and click on "reset new posts" against each section. This will reset the count of how many messages are new to you.

The reason: Every time you visit the forum it looks to see if there are new messages for you. There are about 1.4 million messages and it has to look at the new ones, count them and show you the number or put 'new' next to the messages. There's about 50,000 users on the forum and so this takes time and effort, for the geeks out there there's 16 millions rows in the new_messages_table.

We've also cleaned out lots of old messages and managed to reduce the database from 15Gb to 6 Gb which should speed it up a bit too, which is nice.

[Dopamine1979]

Or 'Mark all messages as read' at the bottom of the page.

[El Pibe]

is there a script you could run which effectively does that for any user that hasn't logged in for, say, 1 month, 6 months or something?

[El Pibe]

in fact if you give me the schema model i'll be happy to write it for you