Results 1 to 2 of 2
  1. #1
    Join Date
    Jan 2008
    Posts
    24
    Rep Power
    0

    Smile xml upload very slow

    Hi all,

    I am uploading xml files into mysql database by parsing them...

    I am able to upload the files, but it is taking a very long time to upload the files which have some 1,00,000 rows.

    I am sometimes also getting the heap space exceptions...

    How to increase the speed of uploading the xml data...
    Do I need to increase my virtual memory.(I am presently using 512 mb).

  2. #2
    Join Date
    Jun 2008
    Location
    Delhi, India
    Posts
    6
    Rep Power
    0

    Default

    You should increase the virtual machine to avoid the heap space error and for speed, You should follow the following step:-
    1. Create the class XYZ, class variable will all xml child tag.
    2. Create Another Class XYZList, extends from arraylist.
    3. Parse the xml, and create the XYZ object and set all value of xml tag to its object, and put inside the XYZList object.

    4. After this, get connection object and put the data inside the database one by one.

    RAM should be atleast 1gb for gud speed

Similar Threads

  1. slow JasperReport
    By bbq in forum Advanced Java
    Replies: 3
    Last Post: 02-11-2008, 09:34 AM
  2. eclipse very slow
    By katie in forum Eclipse
    Replies: 2
    Last Post: 11-05-2007, 11:20 AM
  3. Replies: 1
    Last Post: 07-31-2007, 05:53 PM
  4. Oracle Resultset slow
    By Peter in forum JDBC
    Replies: 2
    Last Post: 07-04-2007, 02:56 PM
  5. Slow reports in Netbeans
    By Alan in forum NetBeans
    Replies: 1
    Last Post: 05-29-2007, 04: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
  •