We have a very large address book (260,000+ entries, 9+ GB) that we have running on ME7.5. The way our users run the app, is to load all records (search on Public owner) first thing in the morning which takes 3-5 minutes depending on the user's PC. The server is a dual 600Mhz XEON, 2GB RAM server with ME7.5 and it's dedicated SQL Server 2000 SP4 running on it. There are less than 10 Maximizer users (our Consumer Relations group)on this system, but they are adding 50-200 entries per day.
We just loaded ME9/SQL Server 2005 on a new server - Dual 3.6 Ghz XEON, 2 GB RAM, RAID drive arrays - separating out data from log files, with only Maximizer to support. A backup of the full ME7.5 database has been restored to the SQL Server 2005 installation, and the ME9 database upgrade performed. All looked good, except when we load the address book - it takes over an hour to load all records. I have done the restore several times using various backup files with no change in performance.
What I have noticed is that on the 7.5 installation, the records load in increments of 1000 (looking a the top of the screen) whereas in the 9.0 version is is incrementing by 100, and loading starts to really slow down after about 15,000 records have been loaded.
This looks like some kind of a setting problem in Maximizer since neither the server, PC or network seems to be overtaxed: server CPU < 5%, network activity low; PC CPU at 50% (hyperthreaded), netowrk activity low as well.
Support has had no suggestions so far - anyone seen something like this before? TIA,
Doug
Original Post