471,887 Members | 1,386 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 471,887 software developers and data experts.

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 1033

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 YellowAndGreen | last post: by
reply views Thread by zermasroor | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.