Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
MSDE vs DBF?
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Titre:
Divers
Thread ID:
00822410
Message ID:
00822997
Vues:
25
>That sound great but as a matter of fact how many sites/machines is your application used and what file server operation systems are used ?
>In case of my applications most of our customers ( several hundred) also had no problems but a few had (especially with Novel Netware file serwer) - I can not say very precisely but it can be about 5% of my customers which exprienced a form of table corruption in last three years. This 5% is too much for me. And I must repeat that sometimes were corrupted tables that were opened only for very short period of time. So for me it is hard to believe that it is possible to completly eliminate DBF corruption just keeping tables closed as long as possible. I still think that using file server technology you can not create reliable multiuser database. I would be happy if you can prove me that I am wrong.

I have NetWare customers - 2 with 3.11 and 1 - 5.0, but they work without mentioned problems. Indeed most of my customers run Win NT or 2000 Servers.
50% of workstations are with Win98, 30%Win2000Pro and last 20% are BG version of WinXP - Home and Pro.
"Short period of time" - this could be a second or a minutes. That's why we open table read/save data and close it. My wife argue that if there are more than 10%(15-20 from 200 tables application)tables opened simultaneously, there are some problems with datamodel. But may be the problem is not in VFP software, may be your customers have problems with hardware and electricity.
Multi-user client-server technology require tables to be closed as much as possible. Only in this case you will not have problems with data.
3-5% crashes is staisfied % according western standards, but for easters with small support fees this is owfull.
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform