Flushing DB

[Ruslan Zasukhin]

on 9/24/03 3:08 PM, Florian Bogeschdorfer at fb at memedia.de wrote:

>> If user edit in some form some single record, then of course it is good
> idea
>> flush it.
>> 
>> If you in batch way modify 1000s records then you can set flush e.g. After
>> each 100. Up to you
>> 
> So you think every 5 minutes regardless to traffic ist not enough?

You can have and 5 minute flush
And some other scheme.

Again, Valentina is able add 100,000 records in 4 seconds. (at least on
local db). After such huge batch Add of course it is good to make flush.
 
> After every single change. Say the user steps through an adress mask and
> enters data. He goes from field to field using TAB and right now I am
> updating the record after every field leave. Should I flush it then as
> often?

Again up to you.
You can do this, or you can NO do this.
In last case of course you get risk loose user's changes in case SERVER
failure on some reason.

If this is local network and it is fast,
And use enter data into FORM as you say,
And you have no 1000 users, then I think you can do Flush after EACH change
in Edit field. Although you of ocurse should check if data really new.

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