Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
VFP reliability (Big database)
Message
From
22/01/2007 09:06:50
 
 
To
21/01/2007 15:39:18
John Ryan
Captain-Cooker Appreciation Society
Taumata Whakatangi ..., New Zealand
General information
Forum:
Visual FoxPro
Category:
Other
Environment versions
Visual FoxPro:
VFP 8 SP1
OS:
Windows XP SP2
Network:
Windows 2003 Server
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01187486
Message ID:
01187638
Views:
17
>Chaim,
>
>This is one of the biggest criticisms of file-based storage: the intermittent unpredictable glitch. The traditional response is to convert to a C/S database that will bring reliability benefits as well as improved security and scaling. It doesn't have to cost a fortune: take a look at mySQL which is an open source C/S Database. We just installed it on a box and pointed VFP RVs at it with no problems (though some of the field types needed tinkering.) If you use VFP views you could easily offer MySQL as an upsizing value-add option. If you distribute MySQL with your commercial product you'll run into licensing costs, but if it is an optional extra you should not experience any price penalty. Alternatively if your customers can afford SQL Server or Oracle you could roll that into an ever bigger value-add and charge a fortune. ;-)
>
>IMHO you *definitely* should raise this with the decisionmakers ASAP. If you don't, somebody else will and they'll have wide support. Iin the past this has resulted in loss of business for some posters here who tried to stick with file storage for the benefit of the customer/s but were outpositioned and outsold by players that picked holes in all the weaknesses of file storage and converted it into a "these guys are putting your business at risk, let us come in and safeguard your data" scenario.

Besides data system contains intricated interface (grid-based), and converting it to client-server could cost a lot.
Edward Pikman
Independent Consultant
Previous
Reply
Map
View

Click here to load this message in the networking platform