Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Free tables slow
Message
From
16/03/2017 15:19:05
 
 
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:
01649108
Views:
75
>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.

Opening files is one of the slowest operations you can do. What some people like to do is open all their tables when the application starts, and leave them open. If you're using private data sessions in your forms, you can just open the tables in the forms, and they'll use the already open files.

Tamar
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform