Community
Showing results for 
Search instead for 
Do you mean 
Reply

Impact on performance when fields with drop-down boxes or dates (with calendars) are added

New Member
Posts: 2
Country: USA

Impact on performance when fields with drop-down boxes or dates (with calendars) are added

We are running ACT Premium 2010 12.1.181.0, Hot Fix 2.   We currently have about 3000 contacts and could anticipate it going to 4000 over the next year.

 

Our database and layout are already quite customized, and would like to add as many as six more contact tabs containing about 10-12 new contact data fields on each .   Some fields would contain just text, but at least 1/3 would use drop-down boxes, and the last 1/3 would be dates, which means there would be a calendar function on them.

 

Our question/concern is about the effect of these additions on ACT's performance.    We don't want to go through the work of adding them only to find they've completely bogged it down.   Does anyone have a sense of scale on when that starts to happen?   Does anyone know the relative effect of

a. adding a new field that's just text

vs.

b. adding a new field that's a drop-down

vs.

c. adding a new field that's a date field that offers a calendar rather than taking the date as just text?

Thanks.

Bronze Super Contributor
Posts: 1,170
Country: USA

Re: Impact on performance when fields with drop-down boxes or dates (with calendars) are added

Being that there alot of variables in the scenario you present, you are likely going to have to run some tests and see how you do.

 

Create a copy of the database and begin adding your fields.  Build up the database and layouts in chuncks and see if your begin to hit a threshold with your system...

Silver Contributor
Posts: 1,813
Country: USA

Re: Impact on performance when fields with drop-down boxes or dates (with calendars) are added

Just as a reference, we have a customized database for Mortgage (HighTrustforACT.com) that has a lot of customized fields of all types.  There are things you can do to keep the layout small, but even with a heavily customized layout, the speed didn't drop significantly. Adding a lot of images did impact the performance,

 

I agree with doing a test first.

Test Drive Act! and Quickbooks over Citrix http://GoTryAct.com

Jon Klubnik| ActTrainer.com
(866)710 4228

ACT! Certified Consultant / ACT! Premier Trainer / ACT! Hosting Provider