Export records to Excel from MySQL
Dear Forum Members,
I am Anz, working as Project Manager.
New to Forum.
Can anyone pls explain my question regarding the performance issuse, while exporting data from MySQL to excel.
We have nearly 40,000 records in employee table and the corresponding transaction table has 30,000 records. We want to make Outer join from Employee table and transaction table.
These combined recordset has to export to Excel.
We are using Apache under windows and Linux. Database is MySQL.
But the performance is very very slow. It takes days, but not finished. Sometimes throwing heap exception.
I would be grateful if anyone give good solutions.
Anubavam Technologies Pvt. Ltd.