What happens if I optimise index

SuiteCRM Forum - English Language SuiteCRM General Discussion
#1

I noticed my index stats as follows:

Total records 139911
Indexed records 761
Unindexed records 139150
Failed records 1
Index file count 57
Last Optimised Never

Should I be concerned it is has never been optimised?
Is it fine to click the button “Optimise” and what would be the effect?

#2

for which table it is?

#3

Hi Ashish,

I just followed the link {web}/index.php?module=AOD_Index&action=index

There is no indicated table.

It was just shown as follows with a button “Optimise Now”

Total records 139911
Indexed records 761
Unindexed records 139150
Failed records 1
Index file count 57
Last Optimised Never

#4

Index helps to use the Search option located on menu tab on. When your Scheduler is working properly, you should not need to optimize manually. Here is a discussion about AOD_index for your information:
https://suitecrm.com/suitecrm/forum/suitecrm-7-0-discussion/1736-what-is-aod-and-how-do-i-use-it

Now take into consideration that the Indexing requires configuration on the scheduled tasks on your server to trigger the Scheduler on SuiteCRM. Check for more information here:
https://docs.suitecrm.com/developer/scheduled-tasks/

Based on my experience is best to modify the scheduler to run on out-office hours because it uses a lot of system resources and it can affect the overall system usability.

IF you find your index is not working properly you might need to Reindex everything by following this tutorial:
https://pgorod.github.io/Reindex-AOD/

Thanks,

AlxGr

1 Like