Recommended production specification for a birt application

shazia

Hi,


I have finally made a nice birt web application with:

- WebViewerExample (Birt Report Viewer) within a java spring web application
- Birt 4.2.0
- on server: Apache Tomcat 5.5
- with mysql server with a database with around 8 gigabyte data


Its time to put my business report application in production, for my company. I think we could get up to 3-4 simultaneously users that use the application to run reports (to run report-querys against my mysql server).

ive got the question from our external it-operations company to tell them what specifications i want for the environment the application will run in.

I would really appreciate if you guys could help me with the specs i should run birt report viewer with. We dont have a big budget, so i hope to get a cost-effective specification, so i am wondering what parts i should prioritize (example: the database server or the tomcat server?)

These are the specs i have come up with till now:
- 1 Virtual Linux server with 7gb ram, Single core Cpu
- 1 Tomcat server with 3 GB RAM (to run birt)
- 1 Mysql server with 1.5 GB RAM

So my questions are:
- What specification parts should i prioritize ? my goal is to run the reports fastest possible.
- Should i for example, get 1 tomcat server with 2 gb and rather have more RAM (example 2.5GB?) on the mysql server ? my birt reports run heavy sql-queries on mysql....i am not sure if i need 3 gb for the tomcat... ?
- I have also chance to get dual core cpu linux server....would it make the processing much faster ?
- What do you guys think ? anyone who has the birt report viewer running in a production environment, any experiences ?

all help appreciated. thanks

mwilliams

You might consider timing the different operations in your report by logging timestamps from your script areas, or something, to see what area of your report could use more hardware. Your db server is probably the main area of concern, but not knowing anything about your data or application makes this all just a guess.