Improve Quick Find (Search) Performance

Hello,

We are running with Version 4.0. We track a lot of emails into our system
regarding different entities. We currently have 8,475 emails tracked in the
system, which has only taken about 4 months to get that many. When we use
the Quick Find or Advanced Search for emails, the CRM client will often times
lock up for up to 20-30 seconds while searching. We have 1 CRM server and 1
SQL server in production. Does anyone have any ideas on improving the
performance?

Thanks,

Chris

klemetsrudj
Tue Mar 04 16:17:01 CST 2008

If you are doing qucik finds on e-mails only in your scenerio, limit the
fields in the quickfind search to as few as needed (created on, e-mail
address, subject are all that display perhaps) and also, the searchable
fields themselves. The more fields you have "searchable" on a quick find the
longer it will take.

Also, check the FilteredView that is used for returning those results and
see if the base table has an index on that particular field you are mainly
searching. It's possible it may not, and in fact putting one on the base or
extensionbase table could assist...just thoughts.
--
John Klemetsrud


"Chris Brown" wrote:

> Hello,
>
> We are running with Version 4.0. We track a lot of emails into our system
> regarding different entities. We currently have 8,475 emails tracked in the
> system, which has only taken about 4 months to get that many. When we use
> the Quick Find or Advanced Search for emails, the CRM client will often times
> lock up for up to 20-30 seconds while searching. We have 1 CRM server and 1
> SQL server in production. Does anyone have any ideas on improving the
> performance?
>
> Thanks,
>
> Chris

ChrisBrown
Mon Mar 24 00:25:01 CDT 2008

Hello,

Thanks for your reply. I have added indexes to the tables and still have no
luck. I have even ran a trace and imported it into the Database Tuning
Advisor and made the recommended changes. Does anyone else have this problem
when searching across the email body?

I currently using the quick find to search Email Body, Subject, Recipients,
Sender, and Actual End.

Please let me know if you have any ideas.

Thanks,

Chris

"TheKlemer" wrote:

> If you are doing qucik finds on e-mails only in your scenerio, limit the
> fields in the quickfind search to as few as needed (created on, e-mail
> address, subject are all that display perhaps) and also, the searchable
> fields themselves. The more fields you have "searchable" on a quick find the
> longer it will take.
>
> Also, check the FilteredView that is used for returning those results and
> see if the base table has an index on that particular field you are mainly
> searching. It's possible it may not, and in fact putting one on the base or
> extensionbase table could assist...just thoughts.
> --
> John Klemetsrud
>
>
> "Chris Brown" wrote:
>
> > Hello,
> >
> > We are running with Version 4.0. We track a lot of emails into our system
> > regarding different entities. We currently have 8,475 emails tracked in the
> > system, which has only taken about 4 months to get that many. When we use
> > the Quick Find or Advanced Search for emails, the CRM client will often times
> > lock up for up to 20-30 seconds while searching. We have 1 CRM server and 1
> > SQL server in production. Does anyone have any ideas on improving the
> > performance?
> >
> > Thanks,
> >
> > Chris