[V4MD] Work wit BLOB/Text fields

Carsten Ilwig Carsten.Ilwig at Portal-RIND.de
Wed Feb 12 18:49:25 CST 2003


Hi Ruslan,
> In fact THE SAME contents you must check in your app, with dirty flag.
> IT is always better do this on APP top level.
Ok, I will do this on my App

> Then Valentina do not compare them. This is stupid for BLOBs.
> Valentina simple write new 5KBs, and delete prev BLOB record.
But how can I get the space from the deleted BLOB rec free for the next rec
or how can I remove this space from the DB?
Only with an XML-Dump??

Best regards
Carsten

----- Original Message -----
From: "Ruslan Zasukhin" <sunshine at public.kherson.ua>
To: <valentina at lists.macserve.net>
Sent: Wednesday, February 12, 2003 11:39 AM
Subject: Re: [V4MD] Work wit BLOB/Text fields


> on 2/12/03 12:17 PM, Carsten Ilwig at Carsten.Ilwig at portal-rind.de wrote:
>
> Hi Carsten,
>
> > still a question to the work with BLOB/TEXT fields
> > If I a record with BLOB and TEXT Fields update. the blb file will be
bigger
> > and bigger and ...
>
> > even if the content of the fields is accurately the same one, how
already in
> > the DB stored.
>
> In fact THE SAME contents you must check in your app, with dirty flag.
> IT is always better do this on APP top level.
>
> > Why is it so and can I prevent this?
>
> IT must not grow each time.
>
> IF you have in .blb e.g. 5KB record, and update it with the same contents,
> Then Valentina do not compare them. This is stupid for BLOBs.
> Valentina simple write new 5KBs, and delete prev BLOB record.
>
> So if you again will do Update that deleted 5KB will be reused.
>
> --
> 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://listserv.macserve.net/mailman/listinfo/valentina
> -------------------------------------------------------------
>
> _______________________________________________
> Valentina mailing list
> Valentina at lists.macserve.net
> http://lists.macserve.net/mailman/listinfo/valentina
>




More information about the Valentina mailing list