Dear Forum Members,

I am Anz, Project Manager.

Here, we have some performance issues while exporting to Excel from MySQL database.

We have 40,000 records in Employee and the corresponding transactions has 30,000 records.

We make outer join from Employee records to transactions records.

While exporting the combined recordset to excel, it takes much times and even days also. But not finished.

Sometimes throw heap exception.

We are using Apache in Windows and Linux, MySQL and Java.

Could anyone please give us good solutions to run very fast or increase the performance.

regards,

Anz,
Project Manager,
Anubavam Technologies Pvt. Ltd.,
Chennai, INDIA.