Is it safe to use valdump while a database is being accessed?

[Ruslan Zasukhin]

On 22/6/07 9:11 AM, "Thorsten Hohage" <thohage at objectmanufactur.com> wrote:

> On 2007-06-22, at 07:03, Steven Ronald wrote:
>> is it safe to use valdump on a database while that
>> database is being accessed (read,add record, update
>> record etc)? ie is there any problem doing valdump on
>> a database while there are active cursors to it that
>> might be adding, deleting or updating records in the
>> database?
> 
> while I'm not able to say anything about "safe" in the sense of not
> "blocking" or crashing the server, I'm able to say that this might
> lead to problems regarding data consistency, because Valentina does
> not work with transactional integrity. So it might happen, that your
> cursors already added the lines of an invoice, then your dumps runs
> and the invoice itself was not added. This would be enough "ensecure"
> for me to think about the process.

I have to think more ...

1) currently Valentina Server will finish dump and will not allow any other
connected user do any task.

2) but this still may lead to data inconsistency because some user could
change T1 but not correct yet T2.


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