Interview Question

arunkumarb

Hi,

What are factors will influence the BIRT report performance?

Please answer me.

Regards,
Arun

bgbaird

Wow Arun, my answer would be anything involved:

Server resources (Processor, OS, Memory, Connections, ......)

Datasource (Flat, Relational, Cached, Web Service, ....)

Network (Bandwidth, reliabilty, packet loss, ...)

Client (See Server)

Report Design (Where does the effort happen, well written, how large a java object,.....)

There are a lot of moving parts, and it really is based on case by case differences.

Do I want the work happening on the database, or in data caching, or at run-time, or in presentation?
Can I leverage objects that are already instantiated?
Is my security model both effective and efficient?
Do I have the right resources in the right place at the right time to meet the requirement?
Does the data need to be "live", or can it be cached (the difference between 5 minutes old and "Live" is very high from a resource perspective)?

This is really just scratching the surface of the question.

Good luck, Brian