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.a...@wien.gv.at>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 >
