I was going to make the same point about SQL Server performance. Properly tuned, it is VERY fast. John may have seen it on a box or network without enough memory, too much other load, etc.
It was an eye opener a few years ago when I was hired to babysit a VFP 6 app that processed millions of transactions a day. My job (as a contractor) was to keep the VFP version running and make minor enhancements while two other guys rewrote the app in C / SQL Server. Having believed for years that "nothing runs like the Fox," it was quite a surprise when the SQL Server version ran rings around the VFP version (on the same hardware). And everything in the VFP version was optimized. Believe me, I checked.
>From the view of "what corporations will use", IMO there are only two choices: .Net with SQL Server and Java with Oracle.
>
>I've seen SQL Server run as fast or faster than VFP. It all depends on how the programming was done and how the network is configured.
>
>Open Source is making inroads, but many corporations are using only Linux and don't accept the development tools/languages yet.
>
>>I have been developing an accounting program since 1990 starting in FPD, thru FPW (horrors), VFP6 and 8 (big learning curve). This program has been added to and bandaided forever. What next ? I would like to choose something that MS is not going to drop, something that is accepted by the corporates so my program and user base is saleable in 10 years time. Is .NET and MS SQL server the way to go ? Or are there other easier to learn options that the suit and tie brigade are comfortable with. After seeing SQL server in action, I am not impressed with the speed, but maybe this will change as computers and the web get faster. VFP has spoiled me rotten with it's fantastic data handling, great functions and easy coding. However I feel I have to start re-writing now (from scratch) because the program is large and I am a slow learner.
>>Any comments ?
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only