How many concurrent users can use in JasperServer

[lawks]

Hi,

I am using JasperServer 3.5 Communication with MSSQL database. A simple report can be generated within 10s for 1 user is online. However when around 10 users are online in different machine. The previous user generate the same report using around 180s. Is there any limitation on the number of concurrent users? or any thead configration need to tune on the JasperServer?

Regards,

K.S.

[sjongenelen]

as ive read in this forum, this presumably has to do with you JDBC/ODBC connection to the database.

 

edit: i checked the forum couldnt find it that fast :P but i know it because Sherman said it :p  it has something to do with the max of 5 concurrent connections :) gl

Post Edited by sjongenelen at 11/17/2009 09:40

[vishal29bhp]

Hi,

Just search "dataSourceObjectPoolFactory" in application-context.xml and by tweaking it u can alter no of connections. and let me know if ur report viewing become faster then before.

 

regards

Vishal

[lawks]

Thank you for your suggestion.

However no change on the performance when increased the value of 'dataSourceObjectPoolFactory'.

Any other factors?

 

[sjongenelen]

yes, everything. Try to run the querys of the reports directly into the MSSQL server. simultaniously ofcourse

[lawks]

The db behavior seems good and can return to those users in a short time simultaneously.

Thanks

[sjongenelen]

if you checked the MSSQL server its safe to say its the jasperserver. Go check/monitor resources on the machine

[suedonne123]

Make sure you do not have debugging level logs turned on for JasperServer...This one bit me last week...I could not figure out why my web service calls were taking so long to return the report structures, etc...I had turned on debug level in the log4j.properties file to debug something else and forgot to set it back...duh...                        :('