Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Users\Data Limitations
Message
De
01/02/2009 07:36:59
 
 
À
01/02/2009 05:45:03
Information générale
Forum:
Visual FoxPro
Catégorie:
Autre
Versions des environnements
Visual FoxPro:
VFP 9 SP2
OS:
Windows XP SP2
Network:
Windows 2003 Server
Database:
Visual FoxPro
Divers
Thread ID:
01378654
Message ID:
01378658
Vues:
14
>Hi
>I ask about company that work via 15 workstations on big VFP database (3.8GB dbc, biggest table size is about 430 MB) .
>
>The company want's to add another 28 users (8 regular and 20 by terminal clients).
>
>
>Do I have to afraid from anyproblem?

The only limitation I can see from your description is the file size. Fox has a 2GB limited on all files; DBF, FPT, and CDX. If you are planning to triple the number of uses, there is a chance that the tables will grow to this max. It would be wise to start considering upsizing the database to a SQL back-end. If you can archive and purge older data from time to time, I would suggest it. Most times history data is accessed only for reporting purposes. If this so for you, then the related reports can access the history tables for the archived data. Also, purging old data will help the overall speed of the application. Every time you access a table, via Fox commands, the entire table is sent to the user. With large tables this can take a while. As the tables grow, the application starts to appear to be slowing down. I have many times in the past have had to address this issue for clients. They either allow the tables to grow to big, or allow to many concurrent users to access them at the same time. Either will cause the appearance of a bottleneck. Using a SQL backend will help if the SQL queries are peformed as Stored Procedures or as SPT will help with not dragging the entire table down each time a table is queried or updated.
Greg Reichert
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform