Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
MSDE vs DBF?
Message
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Miscellaneous
Thread ID:
00822410
Message ID:
00822997
Views:
24
>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.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform