Hi !

Is it possible to reduce the time EDB needs to determine if a certain DDL operation cannot
be executed because of a lock ?

I have to alter live databases manually quite often. Functions/Tables that are not in use
by another session can be altered without problem, but if they are in use, it takes
sometimes minutes until I finally get an "Hey, it is locked" error in EDB Manager.

Within the same machine/same session I get the error instantly.

Heiko

Heiko,

<< Is it possible to reduce the time EDB needs to determine if a certain DDL
operation cannot be executed because of a lock ? >>

Yes, but currently only in code - it's specified in the edbconfig.pas unit.

<< I have to alter live databases manually quite often. Functions/Tables
that are not in use by another session can be altered without problem, but
if they are in use, it takes sometimes minutes until I finally get an "Hey,
it is locked" error in EDB Manager. >>

Is this with C/S or file-sharing ?

--
Tim Young
Elevate Software
www.elevatesoft.com

Tim,

>>Is this with C/S or file-sharing ?

File-sharing. Either it works, or I get the lock error in about 20-30 secs, or it never
completes. Today I left EDB Manager with a "create table" during the lunch break, and an
hour later it still wasn't finished. Killed EDB-Manager after that, tried again - worked.

But don't mind, if this is different with C/S the problem will solve itself after B5.

Heiko

Heiko,

<< File-sharing. Either it works, or I get the lock error in about 20-30
secs, or it never completes. Today I left EDB Manager with a "create table"
during the lunch break, and an hour later it still wasn't finished. Killed
EDB-Manager after that, tried again - worked. >>

Yes, with file-sharing it is up to the OS to determine the timeout for locks
and retries, so it can vary greatly in some cases.

<< But don't mind, if this is different with C/S the problem will solve
itself after B5. >>

Yes, C/S will be consistent (and quick) every time.

--
Tim Young
Elevate Software
www.elevatesoft.com