I know they did some oracle specific settings to make it faster: Server-Side-Table-Chunk-Size: 10000 Next-ID-Commit: T Oracle-Cursor-Sharing: FORCE Oracle-Search-On-Clob: T Oracle-Bulk-Fetch-Count: 100 Clustered-Index: T
I am not sure about DB2 .... you will have to look at the "Configuring AR System" manual. Also you need to look at your workflow to make sure everything is running on an index. Remedy Developer plus can help with that. We no longer run help desk here but if I remember right not everything was indexed properly. Also you might want to encourage users to uncheck the "Refresh Contents on Display" this helps when refreshing tables when you click from record to record. In addition training users to build searches that are indexed helps a lot. Thanks, Sean -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of dcharters Sent: Wednesday, September 06, 2006 4:15 PM To: [email protected] Subject: Re: Increase Performance Remedy 6 So what is your processor at? Is your RAM and Processor at 100% on the application or database server? On Wed, 6 Sep 2006 19:05:46 -0000, [EMAIL PROTECTED] wrote > before to find out the other points you asked me > well, It's a > > Unix Server AIX 5.3 > Remedy 6 > Help desk 6.3 > Websphere 5.1 > DB2 8.1 > > ____________________________________________________________________________ __ _ > UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org -- Open WebMail Project (http://openwebmail.org) ____________________________________________________________________________ ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org
