RE: [Emerald] Another SQL question

New Message Reply Date view Thread view Subject view Author view
Jason Newland (newlandj@areatech.com)
Thu, 8 May 2003 22:00:02 -0500



From: "Jason Newland" <newlandj@areatech.com>
Subject: RE: [Emerald] Another SQL question
Date: Thu, 8 May 2003 22:00:02 -0500
Message-ID: <000301c315d7$16e600b0$1a476ad8@vaio>

Same here, but IEA just said that the problem was limited to my situation, and left it at that. I just wanted to track down the culprit myself....

Jason

-----Original Message----- From: emerald-request@iea-software.com
[mailto:emerald-request@iea-software.com] On Behalf Of Ronnie Franklin Sent: Thursday, May 08, 2003 9:53 PM To: emerald@iea-software.com Subject: RE: [Emerald] Another SQL question

I have to reboot the server about once every 3 months to be able to get reports to even come out. I can generate my own Crystal Reports in seconds, so I know it is not SQL.. Has to be internal to Emerald.

Ronnie

> -----Original Message-----
> From: emerald-request@iea-software.com
> [mailto:emerald-request@iea-software.com] On Behalf Of Jason Newland
> Sent: Thursday, May 08, 2003 8:31 PM
> To: emerald@iea-software.com
> Subject: RE: [Emerald] Another SQL question
>
>
> This is the web based version. The problem exists on any
> machine even the server itself. That is why I think it is a
> delay in the dbase
>
>
> Thanks
>
> Jason
>
>
> -----Original Message-----
> From: emerald-request@iea-software.com
> [mailto:emerald-request@iea-software.com] On Behalf Of Vilmos Branyik
> Sent: Thursday, May 08, 2003 8:06 PM
> To: 'emerald@iea-software.com'
> Subject: RE: [Emerald] Another SQL question
>
>
> Jason,
>
> Sometimes you get the lag when your workstation is not on the
> same workgroup as the server.
>
> Your workstation has to login/authenticate before it can pull
> up the report.
>
> Vilmos
>
> -----Original Message-----
> From: Jason Newland [mailto:newlandj@areatech.com]
> Sent: Thursday, May 08, 2003 6:01 PM
> To: emerald@iea-software.com
> Subject: [Emerald] Another SQL question
>
> Hello everyone,
>
> While running Ver 4.x for the past year, we have had a
> problem with our reports pulling up. It takes about a minute
> for them to pull up each time. I do not know a lot about
> SQL, but I think there is a way to analyze the server when
> pulling up these reports and tell me what proceedure is
> taking so long. If anyone here can help me/point me in the
> right direction I would appreciate it!
>
>
> Jason
>
> ------------
>
> 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
> ------------
>
> 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
>
>
> ------------
>
> 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
>

------------

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



New Message Reply Date view Thread view Subject view Author view
This archive was generated on Thu May 08 2003 - 19:40:56 Pacific Daylight Time