I would glad if you will guide me to make my Global Search work effictively in my SuiteCRM.
It is ttaking 1-2 minutes time while I am searching any data using it.
Kindly also let me know in what sequence I can troubleshoot it.
If you have a test clone, I would try a full AOD reindex to see if it creates a much smaller (and so, faster) index. But if that doesn’t make any magical progress, you’ll have to think about doing some database maintenance, and perhaps some deletes to make your tables smaller.
I am not sure how much of your large database is actually composed of data that is interesting to you. We’d have to look at that in depth, sometimes tables get overgrown, or there are orphaned records (that point to a deleted record), or simply too many records with “deleted=1” which you can eliminate immediately if you’re not worried about the possibility of undeleting them one day.
Do you have the Scheduler job “Prune at 1st of month” active? What does it say in the “Last ran successfully” field? This job cleans up some records with “deleted=1”, though not all.
Do you have old data that you could remove from the database?