Hi,

I have developed a web based application for managing school data. I use MVC 2 - JSP, Struts, Hibernate, MySQL - architecture.
Now, in order to include reporting facilities, we have planned to use MyEclipse reports.

1) MyEclipse reports directly query the database to get the results. Will it cause any issues if I use it in the existing application?

2) Also my database has about 75 tables in all. Does this have any impact on the application's performance?

3) Will a general reduction in the number of tables / associations lead to faster retreivals?

Thanks in advance.