| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Anybody? (was about blob) for lack of a better response....
In the code you sent before, it looked to me as if you were writing only
96K - 3 bytes off the front of each blob to the database in chunks of
32K -1 bytes. Presumably you meant to pass in the size of the blob, subtract
32K-1 from it on each write testing for > 32K-1 remaining before each write
and only writing what is left on the last write.
There is probably some useful performance testing to do on the size written on each write, as well, and the performance results will probably vary according to blocksize and factors affecting the effective size available for writing in each block. This has sometimes been referred to as "chunksize." If you want this routine to be adjustable, then you may want to pass in chunksize, making sure to reduce it to no more than the buffer's defined length.
I didn't proofread your code...
If you do make an adjustable routine and you do some throughput tests the data might be of interest. The last time I tested for chunksize effects on blob writing performance was two storage model revisions ago, before they removed user control of a few things.
mwf
-----Original Message-----
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org]On Behalf Of Hamid Alavi
Sent: Monday, June 07, 2004 4:11 PM
To: 'Oracle-L (E-mail)
Subject: Anybody?
This morning I send an email regarding BLOB just wonder if anybody received it or if anybody have any Idea??
Thanks all
Hamid Alavi
Office : 818-737-0526
Cell phone : 818-416-5095
 |
 |