Re: Query Stuck in running server

[Shams Khan <shams.khan22@xxxxxxxxx>]

Whenever the load of server increases, I find this query running in which seems to me the reason. Is there any other way I can written in such a way so that it doesn't hang up the entire process?

On Thu, Nov 15, 2012 at 2:24 PM, Albe Laurenz <laurenz.albe@xxxxxxxxxx> wrote:

Shams Khan wrote:
> There are few query I found at the time of monitoring below
>
> 00:54:43.574338 |   26952 |   select a.actno,MAX(b.actid) as
actid,MAX(b.actname) as name,MAX(b.phone)
> as phone,MAX(b.email) as mail,MAX(a.subsno) as subs,MAX(t.pkgid
> ) as svcid,MAX(a.expirydt)  as expirydt,MAX(d.domid) as
domid,MAX(d.domname) as domname from actbal a
> inner join subs s on a.subsno=s.subsno   inner join packages t on
s.svcno=t.pkgno inner join account b
> on b.actno=a.actno  inner join ssgdom d on b.domno=d.domno  where
a.actno not in ( select a.actno from
> actbal a inner join subs s on a.actno=s.actno where s.status <= 15 and
a.expirydt > $1) and
> a.expirydt <= $2 and b.domno=$ group by a.actno order by
MAX(d.domname),MAX(b.actname)
>
> can somebody help me to understand it

Understand what?  What is the problem?

Yours,
Laurenz Albe