03-31-2009 02:43 AM
I am currently using the 2005 SDK (9.0) to read a long list of my contacts from an external database.
My goal is to post an update to a specific opportunity of a company/contact. I was able to construct a logic in VB using the sample codes in the help file. However, I am having a performance issue due to the limited option that I have in rendering a filter ( or maybe I am wrong).
It seems that the search in Opportunity is requiring me to scan the entire opportunity table and match it one by one as compared to a direct query.
Bottom line, I am looking for an efficient way to search for a specific set of opportunites by contact.
GetMostRecentOpportunity( CompanyName, ProductName, OpportunityStatus.Open)
Thanks in advance!