Support Forums - View Thread

View Thread

The following is the text of the current message along with any replies.

Messages 1 to 6 of 6 total

Tue, Mar 19 2013 4:32 AM	Permanent 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 AM	Permanent Link
Roy Lambert NLH Associates 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 AM	Permanent Link
David Mahistre	Thank you for your answer I am going to optimize my code
Tue, Mar 19 2013 4:08 PM	Permanent Link
Fernando Dias 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 AM	Permanent Link
Roy Lambert NLH Associates 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 AM	Permanent Link
Fernando Dias Team Elevate	Roy, Yes you are right... I was thinking in terms of Locate when I wrote this. Thanks. -- Fernando Dias [Team Elevate]