From: "Tony Devlin" <email@example.com> Subject: RE: [Emerald] Another SQL question Date: Fri, 9 May 2003 15:06:10 -0400 Message-ID: <GEEJKGMJDENJEJBDENADKEPNCHAA.firstname.lastname@example.org>
Hehe, Don't you just hate "probably" answers. They don't give you that
warm fuzzy feeling we'd all like. =)
I also have the same problem with the report printing and displaying.
And sometimes I'll attempt to do a report and get some generic one of
SomeBSDguy.com ?! .. Anyhow there are apparent problems and I have
attempted the last 6 months to track them down with no avail. I have
cleared up many memory leaks and other problematic queries, but none
that have solved the question at hand.
Essentially I don't have to reboot, I merely shutdown the EmeraldWeb
Service and Restart it. So I know the problem exists somewhere in
If any answers are found please post them as I would greatly appreciate
being able to fix this problem.
[mailto:email@example.com]On Behalf Of Dale E. Reed Jr. Sent: Friday, May 09, 2003 2:54 PM To: firstname.lastname@example.org Subject: RE: [Emerald] Another SQL question
> Also, I walked through the indexing wizard on our system last night
> (sql2000), and it stated that we would achieve a 67% increase in
> if we ran it. Is this something that I should / could do without
> anything? Or will this adversly interfere with Emerald operations?
Adding an index (non-contraint/unique) probably will not affect Emerald.
This is a user supported list. If you require assistance from IEA
Support Engineers, please check out our Support resources at
For more information about this list (including removal) go to: