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

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]

Thank you for your answer
I am going to optimize my code

David,

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

--
Fernando Dias
[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

Roy,

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

--
Fernando Dias
[Team Elevate]