Hey all, I'm hoping someone can help me out here. I've created a intranet recordings site to listen to recorded phone calls for quality purposes. Here's the problem I'm having, once the QA team members log in to the site and then do an advanced search, the page times out. There are indexes on the MS SQL tables as well as script timeouts have been increased for IIS as well as on some of the asp pages. The MS SQL table is huge with over 4 million records. What would be best practices to speed things up? I'm at a loss... My MS SQL statement is as follows:
select
ABCId,
RefNum,
StartDateTime,
FinishDateTime,
PhoneNumber,
Agent,
Recording
FROM dbo.ABCCallLog
WHERE isnull(Recording, '') <> ' ' AND Archive = 0
ORDER BY StartDateTime DESC
As you can see I'm pulling data but I don't want Recording to be blank and the record cannot be Archived.
Once I log into the site and the above SQL statement runs I have about 700,000+ records that meet the above criteria. Again, I'm at a loss and any help would be GREAT! Thanks for your time.