Results 1 to 4 of 4
  1. #1
    ansariazam is offline Member
    Join Date
    Aug 2008
    Location
    Chennai, India
    Posts
    1
    Rep Power
    0

    Default 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.

    regards,

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

  2. #2
    skaspersen is offline Member
    Join Date
    Jul 2008
    Posts
    31
    Rep Power
    0

    Default

    could you post the query you are using please

  3. #3
    Niveditha's Avatar
    Niveditha is offline Senior Member
    Join Date
    May 2008
    Posts
    307
    Rep Power
    7

    Default

    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
    To finish sooner, take your own time....
    Nivedithaaaa

  4. #4
    daGame is offline Member
    Join Date
    May 2008
    Posts
    24
    Rep Power
    0

    Default

    Quote Originally Posted by ansariazam View Post
    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 :)
    Last edited by daGame; 08-06-2008 at 01:16 PM. Reason: wrong interpretation

Similar Threads

  1. Export data to xls
    By trill in forum Advanced Java
    Replies: 5
    Last Post: 03-24-2011, 05:13 AM
  2. How to spool More than 65000 records in IE or Excel in Java
    By santhoskumara in forum Advanced Java
    Replies: 1
    Last Post: 05-06-2008, 04:42 AM
  3. export to excel
    By diana glz in forum Advanced Java
    Replies: 0
    Last Post: 03-13-2008, 11:01 PM
  4. export to excel
    By diana glz in forum New To Java
    Replies: 0
    Last Post: 03-13-2008, 09:26 PM
  5. Export excel issue
    By sanjay_sharma77 in forum Advanced Java
    Replies: 0
    Last Post: 01-10-2008, 03:47 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •