User Has It Right! ....

Kristian Waagan (of Sun's Java DB development team) has really given Java DB (Sun's distribution of Apache / Derby) a new life of its own when it comes to handling CLOBs, starting with Java DB 10.5.

Check out this thread

Note the following testimony from David Goulden:

The performance improvements with CLOBs are dramatic. I created a record with a CLOB containing about 10 million characters using derby 10.4. The following query took over 6(!) minutes:

       SELECT CONTENT FROM MESSAGES WHERE ID = 1

(CONTENT is the CLOB column.)

I then installed derby 10.5 and did a soft upgrade. The same query now takes less than three seconds!

Comments:

Post a Comment:
Comments are closed for this entry.
About

MortazaviBlog

Search

Archives
« April 2014
SunMonTueWedThuFriSat
  
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
   
       
Today