cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
Announcements
290
Views
0
Helpful
0
Replies
phennapa
Beginner

Get response from db_cra is very slow

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

0 REPLIES 0
Create
Recognize Your Peers
Content for Community-Ad