Hi,
I have web application and connect to Cisco UCCX (db_cra) database with uccxhruser username and ODBC driver.
If I query on Database manager program, it's response fast (less than 1 second) but
If I query in my web application, it's response very slow (wait more than 10 minutes).
Example query script
It's count number of total call in 6 months
SELECT count(t1.startdatetime)
from contactcalldetail t1 inner join
(select t2.sessionid, t2.sessionseqnum, t2.nodeid, t2.profileid, t2.targetid, t2.disposition, t1.csqname
from contactservicequeue t1 inner join contactqueuedetail t2
on t1.recordid = t2.targetid and t1.profileid = t2.profileid
where t1.csqname = 'XXXX' and t2.disposition in (2,4)
) t2
on t1.sessionid = t2.sessionid and t1.sessionseqnum = t2.sessionseqnum and t1.nodeid = t2.nodeid and t1.profileid = t2.profileid
where t1.contactdisposition <> 1 and t2.disposition in (2,4) and t2.csqname = 'XXXX' and t1.startdatetime between '2020-06-30 17:00:00' and '2020-12-31 16:59:59'
My web application developed with PHP and Laravel framework.
Please advise whether I should change my query script or make a configuration change at UCCX.
Thanks
Phennapa