Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » DBISAM Technical Support » Support Forums » DBISAM General » View Thread |
Messages 1 to 5 of 5 total |
Transaction verbose |
Mon, Mar 23 2009 8:30 AM | Permanent Link |
"Eduardo [HPro]" | Tim
I have been playing with a lock situation in my application but I can´t realize what is going on. The problem is something like that: Five tables called A, B, C, D, E The time to lock these tables is almost zero. But sometimes other processes are using some of these tables but I don´t know what processes are. My question is: In a situation like that is there any way to know what table is "waiting" to lock ? IOW, table A is locked, table B is locked but table C is waiting (other process is using it in another transaction). I want to know "Table C is waiting". I don´t know if I was clear but I have tried. Eduardo |
Mon, Mar 23 2009 12:00 PM | Permanent Link |
Fernando Dias Team Elevate | Eduardo,
When you say you are trying to lock 5 tables, do you mean you are starting a restricted transaction involving those 5 tables or you are trying to lock each one of the tables using the LockTable method? -- Fernando Dias [Team Elevate] |
Mon, Mar 23 2009 2:49 PM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com | Eduardo,
<< The problem is something like that: Five tables called A, B, C, D, E The time to lock these tables is almost zero. But sometimes other processes are using some of these tables but I don´t know what processes are. My question is: In a situation like that is there any way to know what table is "waiting" to lock ? IOW, table A is locked, table B is locked but table C is waiting (other process is using it in another transaction). I want to know "Table C is waiting". >> Unfortunately, no. However, you can use something like Process Monitor from SysInternals to do so: http://technet.microsoft.com/en-us/sysinternals/bb896645.aspx -- Tim Young Elevate Software www.elevatesoft.com |
Tue, Mar 24 2009 7:24 AM | Permanent Link |
"Eduardo [HPro]" | Fernando
> When you say you are trying to lock 5 tables, do you mean you are starting > a restricted transaction involving those 5 tables or you are trying to > lock each one of the tables using the LockTable method? The first one. I am starting a restricted transaction involving the tables. Sorry for not mention it. Eduardo |
Wed, Mar 25 2009 1:21 PM | Permanent Link |
Fernando Dias Team Elevate | Eduardo,
> Sorry for not mention it. No need to appologise - it was just me being sluguish, as usual Anyway, it doesn't matter because Tim managed to gave you the answer before I managed to understand the question Cumprimentos. -- Fernando Dias [Team Elevate] |
This web page was last updated on Tuesday, September 17, 2024 at 04:19 AM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |