RE: [Emerald] WOW - SQL 7.0 Upgrade

Brian Johnson ( (no email) )
Fri, 6 Aug 1999 13:48:16 -0500

I was told that there are some issues with SQL 7.0 and Emerald security. I
believe that SQL 7.0 "broke" the way that emerald deals with groups in
emerald. Is this true?

Brian Johnson
Internet Specialist
Northern Valley Communications
V:605-225-8945 F:605-229-1563

-----Original Message-----
[]On Behalf Of Dale E. Reed Jr.
Sent: Friday, August 06, 1999 12:28 PM
Subject: Re: [Emerald] WOW - SQL 7.0 Upgrade

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
> 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:

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