Re: [Emerald] WOW - SQL 7.0 Upgrade

Dale E. Reed Jr. ( (no email) )
Fri, 06 Aug 1999 10:27:51 -0700

Duane Schaub wrote:
> I upgraded to SQL7 yesterday, and I cannot believe the difference. I ran
> ten weeks of UpdateCalls_servers and Accounts and Consolidation in about 30
> minutes. Previously, anything over two weeks would not complete after 36
> hours of running and had to be killed.
> Some performance seems slower, such as External Auth. Lookups from NTMail,
> but the larger quearies are many times faster.

I would recommend to any larger site to move to SQL 7. They addressed
several major shortcomins of SQL 6.5. I've seen installs go from 20
hours of processing down to 20 mins of processing for consolidation
after upgrading to SQL 7 (with no other changes).


Dale E. Reed Jr. Emerald and RadiusNT__________________________________________IEA Software, Inc.

For more information about this list (including removal) go to: