Icon View Thread

The following is the text of the current message along with any replies.
Messages 1 to 6 of 6 total
Thread slowness between BDE and DBISAM
Tue, Mar 19 2013 4:32 AMPermanent Link

David Mahistre

Hello I have a problem of slowness between BDE and DBISAM in network configuration without using the server mode
It occurs that there are at least 2 users of connected on the base and with DBISAMTable.findkey
Have already had this problem
Cordially
Tue, Mar 19 2013 4:46 AMPermanent Link

Roy Lambert

NLH Associates

Team Elevate Team Elevate

David


This is a know effect and is due to Windows oplocks and is triggered by a simple change from a single exclusive user to multiple users.

As far as I remember there's nothing that can be done.

On the positive side DBISAM is a lot more stable than the BDE.

Roy Lambert [Team Elevate]
Tue, Mar 19 2013 6:58 AMPermanent Link

David Mahistre

Thank you for your answer
I am going to optimize my code
Tue, Mar 19 2013 4:08 PMPermanent Link

Fernando Dias

Team Elevate Team Elevate

David,

Also make sure you have an index on the fields you are using with Findkey.

--
Fernando Dias
[Team Elevate]
Wed, Mar 20 2013 4:40 AMPermanent Link

Roy Lambert

NLH Associates

Team Elevate Team Elevate

Fernando

>Also make sure you have an index on the fields you are using with Findkey.

From (my old version) help

Call the FindKey method to search for a specific record in a table using the active index.

I know for TTable it HAS to be used with an index (well at least according to Delphi's help) and I think the same is true for DBISAM

Roy
Wed, Mar 20 2013 6:51 AMPermanent Link

Fernando Dias

Team Elevate Team Elevate

Roy,

Yes you are right... I was thinking in terms of Locate when I wrote this.
Thanks.

--
Fernando Dias
[Team Elevate]
Image