469,579 Members | 1,256 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,579 developers. It's quick & easy.

lob, odbc, java and speed

Hi, I have DB2 Workgroup edition, version 7.2, fixpak 7 with a table
column of lob field, sizes of actual data in this field range from 50
to 100 mb. My java application takes FOREVER to query the table and
display the data in this lob column. Any suggestions on how to
increase the speed? Will stored procedures help? Will it help for the
java application to read the lob field in chunks instead of reading it
all at once? Right now for each lob field (contains image data in
binary format) the wait time is about 1-2 minutes which sadly will not
work at all.... :(
Nov 12 '05 #1
0 1012

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

4 posts views Thread by Riccardo | last post: by
reply views Thread by Sean Anderson | last post: by
114 posts views Thread by Maurice LING | last post: by
30 posts views Thread by Mike Cox | last post: by
11 posts views Thread by DJJ | last post: by
reply views Thread by richyy | last post: by
8 posts views Thread by Phil Reynolds | last post: by
reply views Thread by suresh191 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.