[ http://issues.apache.org/jira/browse/DERBY-302?page=comments#action_12313346 ]
Sunitha Kambhampati commented on DERBY-302: ------------------------------------------- I just realized since the link I provided in my earlier comment to mike's email goes to 2 lines .. the link doesnt open up, so attaching the shorter gmane link to his mail and thread on derby dev. http://article.gmane.org/gmane.comp.apache.db.derby.devel/5405 > 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 > Assignee: Sunitha Kambhampati > Attachments: fixclobperf_0609.txt, fixclobperf_0610.txt > > 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
