on 07-13-2009 11:59 AM
Hi,
where can i set Report setting for improvement of performance? like i have to do setting that at a time only 10 reports can open in webi or inview not more than that.... in CMC or other places .
this type of setting where can we do..
could you please asist me where i can do this type of perfomance tuning...
Hello Kumar,
could you please clarify more your Problem. The best to get performance out of a report is the design. Keep it simply and you have better performance.
f.e. a Report with 200 Pages and 100.000 Records is not very perform cause the user maybe only takes a look at the first three pages.
Regards
-Seb.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi there are a lot of ways you can improve the performance
1. increase the array fetch from your universe
2. checking the SQL statement fo the report and add index on the table if needed (based on the where condition that you used)
3. creating partitions on your tables
4. redesign your report
you must be able to check first what is causing the performance issue.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
HI All,
Thanks for reply..
but i want to know Performance improvement on user level in CMC.
like we have 100 rpoert in production server & we have 50 concurrent user ..i want to restrict at a time only 30 concurrent user can open report from Infoview not more than that....like that security seeting i require...
if it is possible then how & where i can do this .....
Hi Kumar,
please do the following: Go in the CMC and select Servers. Open the Properties page of your web server (highlight it and invoke the context menue using the right mouse button). You can set the value of Maximum connections to 30. This way your webi server can serve up to 30 request at the same time. Please keep in mind, that a conneciton will remain open after a report is opened and will be closed only if the relevant timeout expires (Check the Idle Connection Timeout setting on your WebI Server, default value is 20 minutes). You can try to reduce the Idle Connection timeout in order to get the connections be released in time and let new connections be created.
I hope this helps.
Regards,
Stratos
Hi,
normally a single WebI server can serve up to 50 connections. Since the server is multi-threaded you do not have to create two instances unless you want to have a fail-over setup.
Please also keep in mind to consider the performance issue when you design your reports. Badly-designed reports can cuse performance problems in your system even when you open just few of them at the same time.
Regards,
Stratos
Edited by: Efstratios Karaivazoglou on Jul 17, 2009 8:27 PM
Edited by: Efstratios Karaivazoglou on Jul 17, 2009 8:30 PM
User | Count |
---|---|
81 | |
25 | |
12 | |
9 | |
7 | |
6 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.