Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Free tables slow
Message
From
16/03/2017 17:09:50
 
 
To
16/03/2017 12:27:43
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Environment versions
Visual FoxPro:
VFP 9 SP2
OS:
Windows 7
Database:
Visual FoxPro
Application:
Desktop
Miscellaneous
Thread ID:
01649107
Message ID:
01649110
Views:
65
If by "slow" you mean "really slow," like 5 seconds or more, it's likely anti-virus. This will show especially on opening. It would happen on closing if you are using table buffering and have a lot of unsaved records.

That's assuming the tables are on the same machine as the app. If they are on another machine, and turning off anti-virus on the server and on the client (which holds the temp cursors associated with buffering), then you may be experiencing SMB issues.

Hank

>Hi
>
>For a long time, some parts of my software works slow on the network.
>
>Today I found that acces to free table cause the problem.
>
>I used to opens and closes the free tables every time that I access to tables.
>
>Question is whether this is because antivirus,
>or work with external free tables is very slow,
>or I have to leave them open all the time,
>Or any other help.
>
>Thank you
Previous
Reply
Map
View

Click here to load this message in the networking platform