Forum Database is ill.


Author Message
Gizmo

Admin Group

Joined: 05/06/2004
Location: Australia
Posts: 5078
Posted: 12:02am 29 Jun 2019      

Good plan Chopper.

I've disabled the forums email functions, so for now no one will be getting email notifications of new posts.

I'll be going in and cleaning up the database. Lot of members signed up and never posted anything, so I'll clean those up. A lot of inactive members have the email notifications enabled for various topics, which means every time someone posts a post, the forum needs to send out hundreds of emails. So I'll reset everyone's email notifications to off, then you can go in and enable them as you like.

The forums own search function is still disabled for now. The forum uses a Access database, and the posts are stored in a field type called Memo. Memo fields are great for storing a lot of data, but bloody slow when it comes to searching. As there are now over 137,000 posts, that's a lot of slow memo fields to process every time someone does a search.

Glenn
The best time to plant a tree was twenty years ago, the second best time is right now.
JAQ