I've recently encountered a problem in a database with numerous tables of various sizes (a few Kb to ~350Mb).   All data is stored on a server in shared folder.   ~40 PCs are connected to this database using a program written in Delphi 7 + DBISAM 4.31b2

Everything has been working fine up till recently when the user started to notice speed problems.   All PCs appear able to browse the tables quickly but when performing a .Post method on a new/edited record, the system can hang for a variable period of time (up to 45 seconds).   All tables and indexes have been verified and rebuilt, to make sure it's not anything there.

Any advice on where to start looking for a solution?   

(Could this have anything to do with the recent upgrade of a number of the users' PCs to Windows 10?)

Thanks
Andrew

Amina


I don't know the answer but here are some questions:

Is this f/s or c/s?

Is it just users on the W10 PCs that are affected?

Has the AV software changed?

What's the speed like if there's only one user connected and logged in to your app?

Since you say .Post I assume table navigation methods. Is there still the same slowdown if you use SQL?


Roy Lambert