Welcome to the Question2Answer Q&A. There's also a demo if you just want to try it out.
+8 votes
152 views
in Q2A Core by

 How to make faster? I have inserted more than 2M+ questions, answer and comments including users  from my 4 sites. I used localhost server (laragon). 

what will be the best practice for indexing all the data? 
https://prnt.sc/3L-MZkIQbz88

I have to add more  databases later. then the total posts size may be more than 10M+

Here is all the infos; 

Administration center - Stats

Question2Answer version: 1.8.6
Build date: 2021-04-20
Latest version: 1.8.6
Q2A database version: 67
Database size: 3,086.1 MB
PHP version: 7.4.19
MySQL version: 5.7.33
Total questions: 482,158
Total questions unanswered: 68,292
From users: 482,158
From anonymous: 0
Total answers: 2,039,441
From users: 2,039,441
From anonymous: 0
Total comments: 160,623
From users: 160,623
From anonymous: 0
Registered users: 645,702
Users who posted: 569,782
Users who voted: 535,417
Q2A version: 1.8.6

Please log in or register to answer this question.

...