nickvergessen wrote: ↑
Sat Jul 13, 2013 8:26 pm
nickvergessen wrote:I tried to implement that while creating softdelete.
The problem is, it makes the queries way more complex and heavier.
The query run time for the most important queries increase by factor 10.
Will this have an great effect on the performance of phpBB?
On my test back then when implementing the basic of softdelete it doubled the loading time of viewforum in the end.
I don't like processes that slow things down and I know enough about programming to be dangerous. This is a complicated issue especially if guests can post. Running a query is tedious because changing the title or post a bit makes it more difficult to detect, so I can see why it would slow things down a lot.
One option would be to add an email field to the post page for guests so a dynamic IP would not matter. If a member is logged in the field is hidden but if they are a guest they would need to enter an email address to submit a post. A guest's email address would not be displayed anywhere and only visible to administrators during post approval. When a member or a guest hits the submit button unapproved posts would be displayed with a message to not duplicate posts awaiting approval. Searches should be faster because you search by member or email address and post status to display unapproved posts. Once they review their list and select continue, they could could either confirm or abandon the new post submission. If there is no list their post is submitted. This method is not fool proof because someone could still duplicate a post but it would let users see their posts and the status.
I'm not familiar with the inner workings of phpBB so this may not be as easy as I think because a database modification is necessary to add an email address field to the topic for searches. This option has other possibilities. For instance if a guest becomes a member their posts could be moved to the member. Additionally administrators would have either a member or email address associated with all posts on their system.
One might argue guests do not want to submit their email address which is fine. Give admins the option of selecting a radio button in the ACP to disable the function. If the function is disabled, phpBB would work like it does now.
Thought I would throw it out there for other opinions.