Skip to Content
avatar image
Former Member

Scheduling report every 2 minutes....would it affect performance?

I need to schedule my report every 2 minutes.

I save my report to a certain location as CSV file.

If the frequency is short like 2 minutes, would that affect performance...?

If you have experiences in this matter, could you please share...?

Thank you...

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

3 Answers

  • Best Answer
    Apr 04, 2016 at 02:49 PM

    Hi HT,

    It depends on a lot of things, some of them are listed below:

    1. Number of queries being used to create that report and if there are any merged dimensions in the report.
    2. Time duration it takes to refresh that report
    3. Number of rows and columns of data being pulled in the report (Size of the report) and Size of the CSV file being generated.
    4. Network Speed between the BO Server(s) and the location where CSV file will be saved.
    5. The resources on the server which included (number of Nodes if its a Clustered environment) and what are the resources on each node. (Resources like RAM, No of Processors & their speed, No of WebIntelligenceProcessingServers)
    6. Number of Active Users in the Environment

    Let us know answers to as many questions (above) as possible, and hopefully people will respond with their experiences.

    Thanks,

    Mahboob Mohammed

    Add comment
    10|10000 characters needed characters exceeded

    • Hi HT,

      Also, if it makes sense, create a .batch file and schedule it using Windows scheduler to delete those .csv files after certain period (e.g. after few days or a week), as this schedule will be generating 720 files everyday, which is a lot of files and you wouldn't want to delete them manually.


      Thanks,

      Mahboob Mohammed

  • avatar image
    Former Member
    Apr 04, 2016 at 02:43 PM

    Hello HT,

    It depends on the amount of data you are fetching and the machine configuration.

    I have a similar situation where my report is event based whever a change in data it gets triggered but I am fetching very less data so no issues so far.

    Also to add up how many reports are hitting the server for processing at that time.

    Regards

    Niraj

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Apr 05, 2016 at 03:43 AM

    Thank you all for your answers...

    Add comment
    10|10000 characters needed characters exceeded