Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Free tables slow
Message
De
17/03/2017 06:30:27
Cetin Basoz
Engineerica Inc.
Izmir, Turquie
 
 
À
16/03/2017 12:27:43
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Versions des environnements
Visual FoxPro:
VFP 9 SP2
OS:
Windows 7
Database:
Visual FoxPro
Application:
Desktop
Divers
Thread ID:
01649107
Message ID:
01649113
Vues:
57
>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

Free tables are not slower than dbf based ones. Antivirus might be one reason. You shouldn't open them all and keep open all the time. IMHO that is a bad idea. You need to make sure you have necessary indexes. VFP, by nature, is slow over network. It wouldn't be so easy but if you can do, convert to a C/S database (like postgreSQL, SQL server ...).
Çetin Basöz

The way to Go
Flutter - For mobile, web and desktop.
World's most advanced open source relational database.
.Net for foxheads - Blog (main)
FoxSharp - Blog (mirror)
Welcome to FoxyClasses

LinqPad - C#,VB,F#,SQL,eSQL ... scratchpad
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform