[ANN] V4REV MAC 2.4 b10 uploaded

Ruslan Zasukhin sunshine at public.kherson.ua
Wed May 31 01:21:36 CDT 2006


Hi All,

    http://paradigmasoft.com/en/products/download/beta

* In this build should be fixed all glitches introduced by new REINDEX
algorithm for numeric fields. I have test on few databases with up to 100K
records. 


* OPTIMISATION - removed bottleneck in the indexing of non-unique index,
    thanks to this index seems work about 2 times faster now
    on random Search/Add/Delete of single value


-----------------------------------------------------------
[NEW] ** VTable.MaxRecordCount **


This property allows you to optimize your database
if you have some info about data it will keep.

For example, if you know that Table will have only 200 records
then Valentina can use this info to store RecID of such table
in 1 byte instead of 4. This can reduce size of:
    * Indexed of this table
    * ObjectPtr fields that point to this table.
    * BinaryLinks that link to this table.

This is a persistent property. On default it is ULONG_MAX.

About usage of VTable.MaxRecordCount I am going write soon a WIKI page.


-----------------------------------------------------------
[NEW] ** VTable.IndexChanges **

If inOnOff is FALSE then this function drop all indexes of this
Table except UNIQUE indexes and put Table into the state when any
future modifications will not be indexed (except UNIQUE indexes).

This function do not touch system tables and field flags.
Fields still are marked as indexed. So in case of system failure
the next open will just rebuild missing indexes.

This function is very useful if you are going to do some batch
operation, e.g. add/delete a lots of records. When you have finish
you need call this functions again with inOnOff = TRUE,
to rebuild indexed and return table in the normal state.


-----------------------------------------------------------
[CHANGE]

    db.Clone() now use VTable.IndexChanges internally.



-- 
Best regards,

Ruslan Zasukhin
VP Engineering and New Technology
Paradigma Software, Inc

Valentina - Joining Worlds of Information
http://www.paradigmasoft.com

[I feel the need: the need for speed]


_______________________________________________
Valentina-beta mailing list
Valentina-beta at lists.macserve.net
http://lists.macserve.net/mailman/listinfo/valentina-beta




More information about the Valentina-beta mailing list