Speed Up The Loading Of Members Search Results In The Admin

Link: https://support.brilliantdirectories.com/support/solutions/articles/12000071868-speed-up-the-loading-of-members-search-results-in-the-admin

On sites with hundreds of thousands or millions of members, the Search Members page in the Admin can take a long time to load.  One reason this happens is due to a query that checks whether or not there are members that need to be geocoded.


In order to speed up this process, search for the Advanced Setting:


Exact MySQL Queries


System Variable: big_database




When this setting is on the system will not perform the Geocode check and load the Search Members page faster.