You are not logged in.
Hello ReportServer community,
I hope this message finds you well. I've been experiencing some performance issues while using ReportServer, particularly when importing a report into a collaborative space and conducting searches among reports.
The process of importing a report into a collaborative space seems to be taking an unusually long time, and performing searches among the reports is also noticeably slow. This is impacting the efficiency of our workflow.
I wanted to reach out to the community to inquire if others have encountered similar performance issues and if there are any recommended solutions or best practices to optimize the application's speed.
Additionally, I would appreciate insights from the ReportServer team on whether there are specific optimizations or configurations that can be applied to enhance the performance, especially in scenarios involving collaborative spaces and report searches.
Your assistance and guidance on this matter would be highly valuable. Thank you in advance for any information or recommendations you can provide.
Best regards,
Offline
Hi mali29,
do you mean TeamSpaces with "collaborative space"?
Do you have enough memory? Can you pls post a screenshot of your general information page? Administration -> System Console -> General Info.
You can use http://imgbb.com for this.
Regards,
Eduardo
Offline
Hi,
Yes TeamSpaces.
Here is the General Info :
https://ibb.co/WFVnBLY
https://ibb.co/MfnP4YZ
https://ibb.co/vdMjNnR
Regards,
Mali29
Last edited by mali29 (2024-05-21 12:33:06)
Offline
Hi Mali29,
484 MB is definitely too low for ReportServer. Pls adjust the memory settings as explained here: https://reportserver.net/en/tutorials/i … n-windows/
You can check with "meminfo" your memory settings. https://reportserver.net/en/guides/admi … d-meminfo/
Regards,
Eduardo
Offline
Hi Eduardo,
Thank you for your suggestion. I have increased the memory allocation for ReportServer as advised. Unfortunately, the issue persists, and the application is still running very slowly.
Additionally, the performance varies depending on the search query. For example, when I search for "report" the results are instantaneous. However, when I search for "list" I receive a 503 error, even though I have reports that start with the word "list"
Do you have any other recommendations on what might be causing this problem or what I could try next?
Thank you,
Mali29
Last edited by mali29 (2024-05-27 08:11:18)
Offline
Hi Eduardo,
Thank you so much for your assistance. Your suggestion to turn off JIT in the PostgreSQL configuration file solved my issue with the slow search performance. I am grateful for your help.
For the benefit of others who might face a similar problem, here is a detailed procedure of what I did:
Locate the postgresql.conf file:
This file is typically located in the data directory of your PostgreSQL installation. The path can vary depending on your operating system and installation method. For example, on a Debian/Ubuntu system, it might be found at /etc/postgresql/15/main/postgresql.conf, while on a Red Hat/CentOS system, it might be at /var/lib/pgsql/15/data/postgresql.conf.
Edit the postgresql.conf file:
Open the postgresql.conf file with a text editor. You might need administrative privileges to edit this file. For example, you can use nano or vi as follows:
sudo nano /path/to/your/postgresql.confFind and modify the JIT setting:
#jit = onjit = offsudo systemctl restart postgresqlAfter making these changes, the search performance improved significantly, and the issue with the delayed search results display was resolved.
Thank you again, Eduardo, for your valuable help. I hope this detailed procedure will assist others who encounter similar performance issues.
Best regards,
Mali29
Last edited by mali29 (2024-06-03 11:56:19)
Offline
Hi Mali29,
thank you so much for this detailed explanation, I am sure this will help others having similar performance issues with Postgres >= 12.
Regards,
Eduardo
Offline