Hi all,We are in the process of migrating from Sungard Advance to Sage Millennium. We're on Millennium 7.9 running on a 64-bit Windows 2008 server (virtual) with 8GB of RAM; and Oracle 11gR1 on a virtual Linux box with 12GB of RAM.
Approching go-live date, we just stress-tested our system and found both the Giving Detail screen and the Relation screen to be extremely slow:
- Displaying Giving Detail data onto the screen for constituents with many gifts takes an excessivly long time;
- Bringing up individuals or parties with a large number of relationships caused the front end to hang, even if run by only one person.
- In testing simultaneous address updates, it became clear that 5 or 6 simultaneous updates were the limit, after which the system slowed (or stopped).
Has anyone experienced these kinds of performance problems with Millennium? Please share your solutions.
We'll appreciate any help.
Sr. Database Administrator
Bentley University; Waltham, MA.
781 891 2176