Export records to Excel from MySQL

[ansariazam]

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.

regards,

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

[skaspersen]

could you post the query you are using please

[Niveditha]

I feel you can use some 3rd party tools to do this job.

The following link gives a lot of them checl which is feasible for you
Export Mysql To Excel Software

[daGame]

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.

regards,

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

I dont quite understand "But the performance is very very slow. It takes days, but not finished. Sometimes throwing heap exception.
" this sentence of yours :confused:. Are you saying that the 40k/50k records are not read fast? If this is the case there may be several reasons why this happens.
1) Check your design.
2)The way you are reading the records
3)Best use a third party(As someone pointed out?) preferably JExcel by Andy Khan.
4)Is your db table innodb? if yes make that into myIsam

regards,

daGame :)