Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » ElevateDB Technical Support » Support Forums » ElevateDB General » View Thread |
Messages 1 to 4 of 4 total |
Catalog locking time |
Mon, Sep 1 2008 9:30 AM | Permanent Link |
Heiko Knuettel | 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 |
Tue, Sep 2 2008 12:08 PM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com | 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 |
Tue, Sep 2 2008 2:29 PM | Permanent Link |
Heiko Knuettel | 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 |
Wed, Sep 3 2008 3:14 PM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com | 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 |
This web page was last updated on Sunday, May 5, 2024 at 10:18 AM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |