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 <frexp...@yahoo.fr> 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_ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years"