From: "Tony Devlin" <tdevlin@airewaves.com> Subject: RE: [Emerald] Another SQL question Date: Fri, 9 May 2003 15:06:10 -0400 Message-ID: <GEEJKGMJDENJEJBDENADKEPNCHAA.tdevlin@airewaves.com>
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
there.
If any answers are found please post them as I would greatly appreciate
being able to fix this problem.
--Tony D.
-----Original Message-----
From: emerald-request@iea-software.com
[mailto:emerald-request@iea-software.com]On Behalf Of Dale E. Reed Jr.
Sent: Friday, May 09, 2003 2:54 PM
To: emerald@iea-software.com
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
> performance
> if we ran it. Is this something that I should / could do without
damaging
> anything? Or will this adversly interfere with Emerald operations?
Adding an index (non-contraint/unique) probably will not affect Emerald.
Dale
------------
This is a user supported list. If you require assistance from IEA
Software's
Support Engineers, please check out our Support resources at
http://www.iea-software.com/support.
For more information about this list (including removal) go to:
http://www.iea-software.com/support/maillists/liststart