Icon View Thread

The following is the text of the current message along with any replies.
Messages 1 to 3 of 3 total
Thread table occasionally hangs on activate
Fri, Apr 24 2015 7:34 PMPermanent 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 PMPermanent 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 AMPermanent 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
Image