On The Margins

(Masood Mortazavi)


(Books)(Blogger)(java.net)
Check Google Page Rank

20090528 Thursday May 28, 2009

[ Java ] 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!

2009-05-28 11:10:55.0 -- ; Permalink ; Trackback.

Comments:

Post a Comment:

Comments are closed for this entry.

On the Margins Tag Cloud

america apache art berkeley blogs books business canada capital code communications community computing conference connectors content contribution corporate costs culture databases derby design desktop developers development economics education energy engineering film finance history information innovation international internet iran isfahan java java-db javaone law linux logic management markets mathematics media mobile music mysql netbeans networks news open open-solaris open-source opensolaris opensource os persian philosophy phones photography photos politics postgresql practice privacy products programming ruby science server services social society software solaris sports strategy sun sun-microsystems systems technology tehran telecommunications tools transactions transportation travel tv us video war web windows work writing

Del.icio.us

RSS Feeds

XML

All
/ Persian (فارسی)
/Announcements
/Art (هنر)
/Business
/Code
/Culture
/Design
/Economics
/Here
/History
/Java
/Mathematics
/Media
/Networks
/Papers
/Personal
/Philosophy
/Science
/Society
/Sports
/Sun Microsystems Inc.
/Technology
/Telecommunications
/This
/Web
/Work

Disclaimer

I work at Sun Microsystems. The opinions expressed here are purely my own, and neither Sun nor any other party necessarily agrees with them.

Coordinates

Locations of visitors to this page

« November 2009
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

www.flickr.com
This is a Flickr badge showing public photos from M.Mortazavi. Make your own badge here.

Entry Statistics

Entries: 1246
Comments: 919

Recent Entries

StatCounter

Statistics from StatCounter

Page Rank

Check Google Page Rank

On the Margins Tag Cloud

america apache art berkeley blogs books business canada capital code communications community computing conference connectors content contribution corporate costs culture databases derby design desktop developers development economics education energy engineering film finance history information innovation international internet iran isfahan java java-db javaone law linux logic management markets mathematics media mobile music mysql netbeans networks news open open-solaris open-source opensolaris opensource os persian philosophy phones photography photos politics postgresql practice privacy products programming ruby science server services social society software solaris sports strategy sun sun-microsystems systems technology tehran telecommunications tools transactions transportation travel tv us video war web windows work writing

RSS Feeds

XML

All
/ Persian (فارسی)
/Announcements
/Art (هنر)
/Business
/Code
/Culture
/Design
/Economics
/Here
/History
/Java
/Mathematics
/Media
/Networks
/Papers
/Personal
/Philosophy
/Science
/Society
/Sports
/Sun Microsystems Inc.
/Technology
/Telecommunications
/This
/Web
/Work

Other Places




Landmine Casulties
free counters'

Creative Commons License
This work is licensed under a Creative Commons Attribution-NonCommercial-NoDerivs 2.5 License.
© Masood Mortazavi
This is a personal weblog, I do not speak for my employer.