[VSDK] VDK_Text with unique attribute broken?

[Ruslan Zasukhin]

On 11/8/04 9:09 PM, "Eric Forget" <forgete at cafederic.com> wrote:

 Hi Eric,
  
>>> I don't see how this can be a feature, but anyway. I'm switching from
>>> VDK_String to VDK_Text to reduce the size of the database. Some of my
>>> customers felt that it was too big.
>> 
>>> By using VDK_Text, I do not allow to
>>> have longer values, just to taking a lot less space, most of the time. Is
>>> there any other option available?
>> 
>> Then you should use VarChar, not TEXT.
>> 
>> Also what db.segmentSize you use ?
>> Try it smaller e.g. 2-4Kb
> 
> Ok, I will try VarChar. For the segment size, I was using the default one
> 32K. Is there any speed penalty to using a smaller one?

There was info on this list that somebody have test,
And for him the best speed was with 8KB segment

> Also, I'm reducing the block size of some TEXT, real ones this time. As far
> as I understand I need to rebuild the database to allows this, right?

yes

> What
> is the best way, dumping in XML and reloading?

Yes and inside of XML file you can change segment

> I've seen OBL_Dump but
> nothing to reload the database. Is there any sample code or documentation?

You need look at VDK_Database class.


-- 
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
-------------------------------------------------------------