| Forrest Dickinson 2002-10-05, 8:28 pm |
| I have a performance question regarding public folders containing
contacts. I have developed a custom contacts "database" that runs on
exchange 5.5 sp4 with outlook 2002 sp2 as the client. The database is
for a recruiting company and consists of 4 different custom forms:
1. Company Profile Form – custom form that is based on a contact form
2. Contact Profile Form – custom form that is based on a contact form
3. Job Order Form – custom form that is based on a post form
4. Sendout Form – custom form that is based a post form
The forms are all used in one folder in a "hierarchal fashion".
Essentially the user creates a Company with the Company Profile Form.
The user creates a Contact for the company using a custom action on
the Company Profile they created to generate the Contact Profile from
the data contained in the Company Profile Form. And so on and so
forth for Job Orders and Send Outs. There is a view control on the
bottom half of the company profile that displays the contacts for that
company. What happens is that when a user enters the folder the user
sees a view of all the companies in the database (the view has a
filter restriction that filters out Contacts, Jobs, and Sendouts).
When the user clicks on a company to open it, before the company is
opened a subroutine runs that tells the view control in the Company
profile to only display contacts that belong to that company.
This worked great and very fast in the past it only took a second or
two for the company profile to display showing the user all the
contacts that work at that company in the bottom of the company
profile. Now though the database has grown to about 10,000 companies
in the folder and over 40,000 contacts so when a user opens a Company
profile it takes about 7 seconds for the Company to display because
the view restriction takes that long to process.
My question is would upgrading to Exchange 2000 provide a performance
increase in generating these views? I know that Exchange 2k provides
a full text indexing option that would speed up searches
substantially, but are there performance improvements in Exchange 2k
that would speed up view generation as well?
My current setup:
Windows 2000 Domain
2 Exchange 5.5 sp4 servers running on Windows 2000 SP3 neither of the
Servers running exchange are Domain Controllers.
1 of the exchange servers just runs priv.edb database (mailboxes)
the second exchange server just runs pub.edb (the custom database)
Both servers are Dell 4300s
Both exchange servers are Dual PIII 500s with 1.8 gigs of memory and
Raid 5
There are approximately 50 users of the custom database on the network
Sorry for the long post but it was the only way I thought I could
convey my problem. Thank you for any help that anyone can provide me.
|