[ http://issues.apache.org/jira/browse/DERBY-302?page=comments#action_12312888 ]
Sunitha Kambhampati commented on DERBY-302: ------------------------------------------- For Sun JVM ( 1.4.2 _07) the first insert takes 3 minutes but with IBM jvm 1.4.2 it takes about 20seconds on my laptop. Further with Sun JVM you can improve performance if you use the BufferedReader and give a large buffer size to it. Adding this as a comment here so the info is not lost. I have just started looking into this issue, but if someone else has other suggestions etc, please post here/to the list. > Takes over 3 minutes to insert a 500kb String into CLOB > ------------------------------------------------------- > > Key: DERBY-302 > URL: http://issues.apache.org/jira/browse/DERBY-302 > Project: Derby > Type: Bug > Components: SQL > Environment: Windows XP Professional, Dell Pentium IV > Reporter: Glenn Orbon > > I downloaded a Cloudescape Version 10 from here > http://www-106.ibm.com/developerworks/db2/library/techarticle/dm-0408cline/index.html. > Not sure exactly which version of 10 this is. > Would like to store up to a 10MB XML string in a CLOB. However, I noticed it > took over 3 minutes to insert a 500kb string. I am using the > PreparedStatement to get around the 37kb limitation encountered in a previous > issue. It takes less than 2 seconds to insert a 500kb string into a CLOB in > mySQl. > Here the snippet: > FileReader fr = new FileReader ("sample.txt"); > BufferedReader br = new BufferedReader(fr); > String record = null; > try { > while ( (record=br.readLine()) != null ) { > bufferStr.append( record ); > } > } catch (IOException e) { > // > // put your error-handling code here > // > System.out.println("Error reading file"); > } > System.out.println("Size of inputStr: "+bufferStr.length() ); > > PreparedStatement ps = mm.connection.prepareStatement("INSERT into > documents VALUES (?,?)" ); > ps.setInt(1, 13 ); > StringReader reader1 = new StringReader(bufferStr.toString()); > ps.setCharacterStream(2, reader1, bufferStr.length()); > System.out.println("Uploading string...."); > ps.execute(); > System.out.println("Done uploading string..."); > mm.connection.commit(); > Thanks for your the help, > Glenn O. -- This message is automatically generated by JIRA. - If you think it was sent incorrectly contact one of the administrators: http://issues.apache.org/jira/secure/Administrators.jspa - For more information on JIRA, see: http://www.atlassian.com/software/jira
