weird BLOB problem

Ruslan Zasukhin sunshine at public.kherson.ua
Fri Jun 4 23:28:47 CDT 2004


On 6/4/04 10:12 PM, "Chris Sheffield" <cm_sheffield at yahoo.com> wrote:

> Thanks, Ruslan.  I will try a server-side cursor and
> see if that helps.  I've just been doing the default,
> which is client-side correct?

yes
 
> I did find that increasing the segment size on the
> field helped tremendously.  But I noticed that the max
> segment size that can be set by VApp is 999999.  Is
> there any way to make this larger?  Would it be bad to
> make it larger?

Wow. Never do that !

999999 bytes for segment ???

This means that even if you store 10Kb into BLOB it will eat
999999 bytes on disk. Very not reasonable!

And I do not think that this may help.

May be such big segment have cause error inside of sever,
And data was not sent?! then it looks to you to be faster.


-- 
Best regards,
Ruslan Zasukhin      [ I feel the need...the need for speed ]
-------------------------------------------------------------
e-mail: ruslan at paradigmasoft.com
web: http://www.paradigmasoft.com

To subscribe to the Valentina mail list go to:
http://lists.macserve.net/mailman/listinfo/valentina
-------------------------------------------------------------



More information about the Valentina mailing list