Performance issue v15

Performance issue v15

Posted by: p.feenstra on 11 April 2021, 9:46 pm EST

• 

  p.feenstra

  • Post Options:
  • Link
    Copy

  Posted 11 April 2021, 9:46 pm EST

  Upgraded my ActiveReports v10 to v15

  Using:
  
  Vs2019, Framework 4.8, Vb.Net, WindowsForms application

  Performance test:
  
  When I run (print preview) code with v10 it took 2287 milliseconds to complete.
  
  When I run the same code with v15 it took 11003 milliseconds to complete (about 5 times slower).

  Noticed that:
  
  the application is not able to find …\bin\debug\Grapcity.ActiveReports.config.
  
  But I don’t have such a file (should be in the Tools directory?)

  Any idea what is going wrong here?

  Kind regards,
  
  -PietF

• 

  piet.colle

  • Post Options:
  • Link
    Copy

  Posted 14 April 2021, 11:35 pm EST

  Hi Piet,

  I see that you are doing this during debug of your application.
  
  I have noticed that a lot of messages are send to the output console during debugging. This slows down the report engine tremendously.
  
  Luckily, this does not occur In release mode.
  
  I have send a request to GrapeCity to turn the debug messages off or at least have a feature that you can use to switch it off.

  I also do not have the config file but it is not complaining.

  Regards,
  
  Piet Colle

• 

  mohitg

  

  • Post Options:
  • Link
    Copy

  Posted 15 April 2021, 5:06 am EST

  Hello,

  Can you please share the sample with us so that I can check the issue at my end.

  Thanks,
  
  Mohit

• 

  p.feenstra

  • Post Options:
  • Link
    Copy

  Posted 19 April 2021, 1:08 am EST

  Thanks Piet for your input, appreciated.

  Mohit,

  Sharing the sample is not an easy task, but you can watch my screen if you want.

  I tried to narrow down the issue and found that the delay arises between the PageStart events.
  
  Observations:
  
  FetchData uses less than a millisecond per data row
  
  Details Format uses a millisecond or less
  
  PageStart to PageStart uses approximately 430 milliseconds at a time, so…

  Hope you can help me.

  Regards PietF

• 

  mohitg

  

  • Post Options:
  • Link
    Copy

  Posted 19 April 2021, 6:00 pm EST

  Hello,

  Can you please check with latest build with AR15.1 and share the result with us.

  Thanks,
  
  Mohit

• 

  p.feenstra

  • Post Options:
  • Link
    Copy

  Posted 19 April 2021, 7:45 pm EST

  Mohit,

  Where can I find the AR15.1 download? (Newest appears to be AR15.0)

  Regards,
  
  Pietf

• 

  mohitg

  

  • Post Options:
  • Link
    Copy

  Posted 21 April 2021, 2:19 pm EST

  Hello,

  It is not officially launched but it is released on the NuGet server. Can you try to upgrade the AR package through the NuGet Package Manager.

  Thanks,
  
  Mohit

• 

  p.feenstra

  • Post Options:
  • Link
    Copy

  Posted 22 April 2021, 1:58 am EST

  Mohit,

  Updated to AR15.1 but the issue still exists.
  
  Most report files are more then 15 years old an have had several AR updates.
  
  (but under v10 all seems ok)

  Any ideas?

  Regards,
  
  PietF

• 

  mohitg

  

  • Post Options:
  • Link
    Copy

  Posted 25 April 2021, 2:02 am EST

  Hello,

  If you can share a single report with which I can replicate the issue my end, would be very helpful for us.

  Thanks,
  
  Mohit

• 

  p.feenstra

  • Post Options:
  • Link
    Copy

  Posted 26 April 2021, 9:15 pm EST

  Mohit,

  in the attachment you will find a simplified report along with some other files you will need. (VS 2019, Framework 4.8)
  
  In my environment it completes in about 4350 milliseconds (v10 needs about 1050 milliseconds)

  Hope you can find the culprit.

  Kind regards,
  
  PietF

  performance-issue.zip

• 

  mohitg

  

  • Post Options:
  • Link
    Copy

  Posted 27 April 2021, 5:04 pm EST

  Hello,

  I have observed the performance difference at my end but not as much as you described at your end.

  AR10: 523 Milliseconds
  
  AR15: 1179 Milliseconds

  My environment detail:
  
  OS: Win10 19042
  
  RAM: 16 GB
  
  Processor: Intel(R) Core™ i7-10850H CPU @ 2.70GHz 2.71 GHz
  
  HardDisk: Micron 2300 nvme 1024gb

  Please refer to the attached sample.

  Could you please compare the performance difference at your end with attached sample and also share the environment detail with us.

  Thanks,
  
  Mohit
  
  PerformanceCheck.zipPerformanceCheck10.zip

• 

  p.feenstra

  • Post Options:
  • Link
    Copy

  Posted 28 April 2021, 3:24 am EST

  Mohit,

  AR10: 1318 milliseconds
  
  AR15: 5030 milliseconds

  Environment:
  
  OS: Win10 Pro 19041.928
  
  RAM: 8GB
  
  Processor: Intel(R) Xeon(R) CPU E5-2620 v3 @ 2.4GHz
  
  HardDisk: 238 gb (SATA)

  Kind regards,
  
  PietF

• 

  mohitg

  

  • Post Options:
  • Link
    Copy

  Posted 2 May 2021, 3:43 am EST

  Hello,

  I have escalated the issue to the development team (AR-26495) and will inform you once I get any information from them.

  Thanks,
  
  Mohit

• 

  mohitg

  

  • Post Options:
  • Link
    Copy

  Posted 5 May 2021, 4:56 pm EST

  Hello

  Can you add the following line before rpt.Run()
  
  rpt.Document.Printer.PrinterName = “”

  Thanks,
  
  Mohit

• 

  p.feenstra

  • Post Options:
  • Link
    Copy

  Posted 5 May 2021, 7:43 pm EST

  Mohit,

  you found the culprit!!
  
  AR15 now needs 853 milliseconds to complete so we even gained performance!

  Is this a breaking change by the way? I can remember that when a system has no standard printer AR would not print.

  Kind regards,
  
  PietF

• 

  mohitg

  

  • Post Options:
  • Link
    Copy

  Posted 6 May 2021, 5:38 pm EST

  Hello,

  It is workaround as of now and it is fixed in the upcoming build.

  when a system has no standard printer AR would not print.
  
  In my suggestion, you can set the PrinterName to your default printer name so that you would not face any issue.

  Thanks,
  
  Mohit

• 

  p.feenstra

  • Post Options:
  • Link
    Copy

  Posted 8 June 2021, 9:37 pm EST

  Mohit,

  is it fixed yet?
  
  If so, where can I download the update? (AR standard)

  Kind regards,
  
  PietF

• 

  mohitg

  

  • Post Options:
  • Link
    Copy

  Posted 8 June 2021, 11:30 pm EST

  Hello,

  It is fixed in the latest AR build. You can install the latest version from the following installer.
  
  https://www.grapecity.com/activereportsnet/download

  Thanks,
  
  Mohit