09-21-2010 07:58 AM
We are running ACT Premium 2010 22.214.171.124, 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
b. adding a new field that's a drop-down
c. adding a new field that's a date field that offers a calendar rather than taking the date as just text?
09-21-2010 09:28 AM
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...
09-22-2010 09:41 AM
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.