[NEW] properties for VTable class, Will be available in 2.4 b10

Ruslan Zasukhin sunshine at public.kherson.ua
Mon May 29 11:24:33 CDT 2006


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



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



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




More information about the Valentina-beta mailing list