Hello,
I created quick report, but it joins columns from multiple views and loading this quick report is slow. Can I add some timer in this quick report, which will display how long is loading the report and after successfull load it will stop?
Thanks
+6have same question, wait for someone more information regarding this topic.
Do the tables you query on have lots of data? It could be a matter of some basic SQL tuning to start with. Sometimes, indexes on tables in IFS aren’t quite what you expect.
Also, does the report return lots of data, like thousands of records? If so, what’s the purpose of that? I know some people prefer to dump things to Excel and fiddle with the data there, but a group and sum is much more efficiently performed in the database, i.e., the report itself.
Feel free to share the select statement, as well as the IFS Cloud version.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
