- Posts: 725
- Thank you received: 15
Some reports super slow to open,
- hanisultan
-
Topic Author
- Offline
- Platinum Member
-
Less
More
8 years 7 months ago #12422
by hanisultan
Some reports super slow to open, was created by hanisultan
The reports are all SQL. When I open the report, not run, it seems like it is running the report in the back, same when I switch between different tabs (Page1, Data, etc ) When I close it too. Not all reports just this one . What do you need from me?
Please Log in or Create an account to join the conversation.
- Peter.Jonson
-
- Offline
- Platinum Member
-
8 years 7 months ago #12427
by Peter.Jonson
Peter Jonson
ETL Developer
Replied by Peter.Jonson on topic Some reports super slow to open,
This can be because report generator is trying to get list of fields from the database.
If sql is very slow it will take a while.
If you use parameters you can speed it up by using different default parameters
Or you can add some indexes to make SQL faster
If sql is very slow it will take a while.
If you use parameters you can speed it up by using different default parameters
Or you can add some indexes to make SQL faster
Peter Jonson
ETL Developer
Please Log in or Create an account to join the conversation.