If there are many questions, such as 1 million or 10 million. Will the site have performance issues? Has anyone tested it?
1 Answers
Performance of any service like this depends on the database in use, the underlying hardware specs, server connection speed and how well the database is optimized for this.
If you put this forum on a raspberry pi and have a database that is several GB, it wont be a great experience. However With decent hardware, huge amounts of sql entries (talking gigabytes of data) shouldnt be a problem for mysql or postgres if the underlying structure is decent.
Realisticly though, you will never reach a point of choking because of the amount of data you would need for that to happen.
Related Questions
When I turn on WeCom plugin, how can I use email and password to register?
1 answers
How to convert mysql to sqlite?
2 answers
How does Golang compare to PHP, Node.js, and Ruby in terms of advantages and disadvantages for incubator-answer ?
Creating a RAG ChatGPT AI that uses my Q&A site as context/source of data?
In the incubator-answer code, what is the difference between common in tag.TagService and tag_common.TagCommonService? Why is it designed this way?
1 answers
Should I use database extraction or web crawling for OpenAI assistant Q&A integration?