SQL*Net message to client wait
Yellowfin 7.1 on Windows Server 2012 R2 64Bit
When I edit a report and then save returning the saved report takes a long time. If I look at the Sql call at the database I see a lot of "SQL*Net message to client" against table cachedfiltervalue.
Nearly all my reports use an access filter with 160 odd entries so cumulatively the query need to return
Most reports have up to 6 'dependent' filters
I have a LOT of cached filters some of which have a lot of rows. The table contains > 12M rows.
Sample query attached:
Anyone any ideas on how I can improve the situation?
DB Stats are up to date, all the indexes are in place
I am the admin/DBA so any parameter changes welcome :)