Cash Book Poor Performance

Legacy Contributor

Is anyone else experiencing very slow Cash Book performance?
When users run single line reconciliations, it takes 2 minutes for the process to complete. But when users try to do multiple lines, the process times out in Smart Office and Portal (multiple lines can be successfully processed using LID).
We have opened a case with Infor and they had us rebuild indexes on CBTRANS and CBCONSOL which did not solve the issue. To resolve the time out issue, Infor had us increase the read/write time out for IOS from 60 seconds to 900 seconds which did resolve the timeout issue.
· Our application, web, database, LBI and Smart Office servers are running Windows Server 2008 R2
· Database engine is SQL Server 2008 R2
· IBM Websphere 7
· Lawson S3 Core Technology 9.0.1.12.204
· Lawson S3 Applications 9.0.1 MSP 7
· Lawson EMSS 9.0.1.5
· Infor Smart Office 10.0.5.4.10
· Lawson Business Intelligence 9.0.4.2.136
· ViewPoint 10.1.0.2151