+1 on this. We had serious load times on our audit logs, adding additional indexing took the form load down from ~30 to about ~2
Best, Jon _____________________________________________________ Jon Slaven | Amway | 616-787-7132 | [email protected] From: Patrick Zandi <[email protected]> To: [email protected], Date: 06/26/2013 07:53 AM Subject: Re: performance issue Sent by: "Action Request System discussion list(ARSList)" <[email protected]> ** You need to optimize your report and add indexes to your forms based on your query to drop your return times. I suspect you are table scanning Math is always on the right side of your query. IE. datefield >= ($timestamp$ - xxx) Not reversed Always use and equal sign in every query to use the index. Try not to use != Helpful hints Sent from my iPhone On Jun 26, 2013, at 7:26, Frex Popo <[email protected]> wrote: ** Hi everyone, In addition to a reporting server, we have some 10 forms in a primary server with large volume of data. Adhoc AR Reports and searches are executed on the data nearly every day and this is causing some serious performance issues. Any thought on how to resolve this? We were thinking about moving the data to a different database (thorough replication or nightly database copy) but we need either an additional server (perhaps DSO) but this will need an extra license. Enabling archiving at the form level is another option but we will still have to use the primary server and additional configuration needs to be done at the queues and thread level as well and plenty of table indexing. Any pointer will be very much appreciated. BTW this is ARS7.1 Thank you frex _ARSlist: "Where the Answers Are" and have been for 20 years_ _ARSlist: "Where the Answers Are" and have been for 20 years_ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years"
