I am using ContactsApp in Google Drive Add-On to fetch contacts when user types in input box . If I have many contacts ContactsApp.getContactsByName responds very slowly . I have around 5000 contacts and this method takes around 40 seconds to respond. I logged the times to test. One of my clients has around 20,000 contacts and he cannot see results of search. How can we improve performance of ContactsApp.getContactsByName ? We cannot fetch or cache 20,000 contacts.
I saw a similar question which is unanswered ContactsApp Performance