Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » DBISAM Technical Support » Support Forums » DBISAM General » View Thread |
Messages 1 to 3 of 3 total |
table occasionally hangs on activate |
Fri, Apr 24 2015 7:34 PM | Permanent Link |
Monte Etherton | I'm trying to track down a delay when a table is activated, and I've spent quite a bit of time trying obvious solutions.
What I see is about a 30 second delay between the BeforeOpen event and the AfterOpen event. It only seems to occur when multiple users (e.g. 5 or so) are logged on. I have rebuilt the table and the index. Can you tell me what happens internally between those 2 events? That may help me find out what I'm doing wrong. Or please offer any other insight or "try this" suggestions... I'm using Delphi 7/DBISAM 4.40. Table is 30mb, idx is 48mb thanks, Monte |
Sun, Apr 26 2015 9:28 PM | Permanent Link |
Adam H. | Hi Monte,
Regarding the other users that are logged on - does your application have any transactions in it. (ie, StartTransaction... do something... EndTransaction). If so, could one of these be locking the database, and causing the delay? Cheers Adam. |
Mon, Apr 27 2015 4:35 AM | Permanent Link |
Matthew Jones | Monte Etherton wrote:
> about a 30 second delay Sounds very like a network timeout to me. I'd look for something that is not there, like a mapped drive, or a printer offline. -- Matthew Jones |
This web page was last updated on Thursday, March 28, 2024 at 06:05 PM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |