jihuayu commented on issue #569: URL: https://github.com/apache/incubator-answer/issues/569#issuecomment-1774015083
Adding a unique index to the `title` is not a good practice for the following two reasons: 1. There is no requirement for the `title` to be unique in product design. Adding a unique index solely to prevent duplicate submissions is not a good practice. 2. Add index to long text is not a good practice as it can potentially impact insertion performance and increase database size. I think we need to do the following: 1. Add a loading state to the submit button to prevent duplicate clicks during the HTTP request, which can also improve the interaction experience in weak network conditions. 2. Add a UUID to POST requests to filter out duplicate requests on the backend. -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: [email protected] For queries about this service, please contact Infrastructure at: [email protected]
