You are viewing a plain text version of this content. The canonical link for it is here.
Posted to ojb-user@db.apache.org by q <to...@msn.com> on 2002/12/30 14:33:14 UTC

Performance on getting/setting data to Blob field

hi,
I using the MSSQL 2000 as the file store,
and design a class with a field type as LONGVARBINARY
I found the performance is very slow when I load an object with blob field
I have no idea if there exist any other way to improve it ?

here is my environment
=====================
P3 700 RAM265
WIN 2000/MSSQL 2000
JDK V1.4
=====================
Data 8426 bytes
Ojb v0.9.7 Took 184 sec to return .(using broker.getObjectByIdentity())

any suggestion will be appreciate.
Regards,
tony


_________________________________________________________________
MSN 8: advanced junk mail protection and 3 months FREE*. 
http://join.msn.com/?page=features/junkmail&xAPID=42&PS=47575&PI=7324&DI=7474&SU= 
http://www.hotmail.msn.com/cgi-bin/getmsg&HL=1216hotmailtaglines_advancedjmf_3mf