FiveTech Support Forums

Unfortunately, we have no alternatives available. It is very sad.

when DBF is used in Share Mode only Once, it will use SMB "Exlusive Locking" Mode
as soon when DBF was opened second Time it will switch into "Opportunistic Locking"

To All

Like Otto mentioned in one of his posts ... when I start my .EXE on a network or local app I test for the local workstation folder "C:\dbtmp" and when I write reports I always create my temp .dbf's and .cdx's on the local machine "C:\dbtmp\ ......,,dbf Order "C:\dbtmp..... .CDX and open the reports from the common network drive ... and when I am done with the report I delect the local \dbtmp files ..

I have done this for years in shared very large Novell networks and never had a speed issue ..

Rick Lipkin

I just noticed this topic.

And I can only share my experiences on this matter.

I also use DBF and CDX on network and on different kind of servers (Windows, Linux, NAS, ...).

It has been many years ago that I had any speed problem.

I remember the SMB2 problem on old Windows versions, but since Windows 7, I never experienced the problem again.

I have database which often are as big as 2 GB with sometimes more than 50 indexes in the CDX.

So, I get the impression that something must be wrong in the hardware is speed is a problem.

This happened to my twice, but meanwhile more than 10 years ago: a customer of mine was experiencing that my software was running very slowly. I spook about it with his PC-supplier.

Suddenly the supplier suggested to replace the motherboard of the PC, although all other software was running just fine. He replaced the motherboard and the problem was completely gone.

One year later, I had the same problem on the system of another customer. The same action solved the problem.

Just saying.

Michel,

>often are as big as 2 GB.

I assume these are DBF files with memo fields.

If I’m right, how large are your DBF files and your FPT files?

Best regards,

Otto

Michel,

Did you try my sample? It demostrates that there is a problem that is not related with the specific PC or network.

Otto,

I never use fpt-files for memos.

In stead, I create fields of 2000 or more characters and handle like they are memos.

If a fpt-files gets corrupted, I experienced problems to open the DBF-file.

So I decided not using FPT-files anymore.

Michel,

Did you try my sample? It demostrates that there is a problem that is not related with the specific PC or network.

#include "Dbinfo.ch"


REQUEST DBFCDX
REQUEST DBFFPT


FUNCTION MAIN()

    LOCAL nSec

    RDDSETDEFAULT( "DBFCDX" )

    SET DBFLOCKSCHEME TO DB_DBFLOCK_CL53EXT

    USE \\yourserver\yourfolder\yourdbf SHARED

    SET INDEX TO \\yourserver\yourfolder\yourcdx

    nSec = SECONDS()

    WHILE !EOF()
        SKIP
    ENDDO

    ? SECONDS() - nSec

    INKEY( 0 )

    RETURN NIL

MarcoBoschi wrote:Today I hope to try again the enable Set-SmbServerConfiguration -EnableOplocks $false

Marco,

I never have seen this line before : SET DBFLOCKSCHEME TO DB_DBFLOCK_CL53EXT

Please, can you explain this to me?

Thanks.

Otto,

Thanks a lot for this info.

I'm going to have a look at it in the coming days.

And where do I get dbInfo.ch?

It is not included in FWH?

Thx.