October 28, 2007 in Feedback
I go to a forum with a relatively high member account (37393 at last check). Most of these accounts are inactive, but this member often gets extended periods of times where there is an error message about the board not working properly. Could this have anything at all to do with the large amount of inactive accounts, or just from the constant level of high activity on the forum?If the inactive accounts were deleted, would the board run better, and with less chance of problems?
I gather it would technicly have an effect because of database size. The bigger effect would come from activity on the actual forum it self.
If I'm not wrong (I may be - I don't remember exactly the query), the query uses 'WHERE' clause. So I don't think that's an issue with the index. But if you have a big amount of posts, it may be a problem, since MySQL will have to parse a huge Fulltext index. It depends on how big is your board. I don't think that the number of member may be an issue.Can you give us the error message you get when your board isn't working properly?
But if you have a big amount of posts, it may be a problem, since MySQL will have to parse a huge Fulltext index.
If the owner is having resource problems they should submit a ticket.As to the general inquiry, the raw number of members will have little impact on how the site runs, assuming the database indexes are correctly in place. What affects the speed of the site more is the number of members concurrently using the site.
This topic is now archived and is closed to further replies.
Started 29 minutes ago
Started 2 hours ago
Started Tuesday at 11:54 PM