Rules for Valentina DB maintenance

Thu Jan 29 10:40:13 CST 2004

on 1/29/04 2:17 AM, Trevor DeVore at lists at mangomultimedia.com wrote:

Hi Trevor,

> I will be releasing my first Revolution software title which uses
> Valentina for the database in the near future.  I'm wondering if I need
> to build in a periodic call which will call the compact, defragment,
> etc. calls after it has been installed on the customers system.

May be better give this as menu functions for user?
Also good to have XML dump/load

> Most of the tables will only have a read performed on them.  There are
> one or two tables that have data updated in them on occasion.  Are
> there any rules for how often compact, defragment, etc.?

COMPACT you need only after MANY DELETEs

DEFRAGMENT -- after MANY INSERTS.

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