I am working with an Outlook third party solution that we are using for our Guest Services department. We are storing Contacts, their related Service issues, and their related Notes as items on our Exchange Server and accessing through customized Outlook forms.
1 contact to many service issue
1 service issue to many notes
The Service issues of a given contact are displayed in a listview on a custom Contact form
The Notes of a given Service Issue are displayed in a listview on a custom Service Issue form.
My question is regarding the performance of the find and restrict methods. We currently have 50,000 contacts, 52,000 service issues, and 240,000 Notes. When you open a contact which triggers the population of it's Service Issues, it searches through the available 52,000 using the find method. This can take upwards of a minute. Upon opening subsequent contacts, Outlook appears to use a cache since the search only takes around 3-4 seconds. However, this "cache" goes away after a period of time. Then the population of Service Issues again takes up to a minute. You can imagine how long the initial search takes when finding the associated notes of a given Service Issue
Are there any settings on the Exchange server to utilize the cache more efficiently? Is there any sort of indexing available? We are using an ID field (20 to 30 bytes) as the key to the given item. Is the size of this ID field an issue
Any help would be greately appreciated