Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
VFP not mentioned in MSDN subscription ad
Message
 
À
30/01/2002 04:04:31
Walter Meester
HoogkarspelPays-Bas
Information générale
Forum:
Visual FoxPro
Catégorie:
Autre
Divers
Thread ID:
00605216
Message ID:
00613793
Vues:
33
Walter,

>There are a lot of things you can do about this, however a lot of depends on the nature of your application. Reclycling records and using random generated PK fields help to let your indexes say balanced and keep the tables compact. Table or row buffering with transactions helps to avoid almost all corruption problems i've ever encountered.

If you're saying "Begin Transaction", these gives us a lot of file locks if you have 100 plus users connected/accessing specific table. I don't know why? I presumed it's the limitation of VFP table. Before, we blamed the server, cabling, etc. In short we upgraded Server and did recabling but the problem still occured. I already asked it here in UT before and the consensus was, we must consider whiching to high-end databases, and so we did. SQL Server is not a silver bullet solution to problem but stable enough.
JESS S. BANAGA
Project Leader - SDD division
...shifting from VFP to C#.Net

CHARISMA simply means: "Be more concerned about making others feel good about themselves than you are in making them feel good about you."
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform