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