Because users have a very high search frequency, and considering there are 800,000 topics, I am wondering whether some customized search solution might be necessary.
Depends on your disk performance. If your disk is too slow (IOPS) and your database can’t be cached in memory for most operations, it can quickly become a bottleneck.
Not really, but your specific usage pattern may discover some corner cases. At this scale, specially on the first month it’s a good idea to keep an eye for slow pages and checking if the database needs more resources, vacuum or tuning.
it is currently running on a privately developed PHP-based system. However, I believe Discourse would be more suitable and efficient for our needs, and its maintenance team appears to be very professional.
Therefore, we are considering migrating to Discourse.
Not wanting to appear over-praising, but yes, they are.
Solid ethics (rare enough to be emphasized), solid skills, well-maintained software, always moving forward rather than falling behind on outdated technologies, and excellent support both from the devs and the community here on meta.discourse.org.