Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Moving from Foxpro to C# or Java. Which one?
Message
From
18/05/2005 19:25:01
John Ryan
Captain-Cooker Appreciation Society
Taumata Whakatangi ..., New Zealand
 
General information
Forum:
ASP.NET
Category:
Other
Miscellaneous
Thread ID:
01014647
Message ID:
01015632
Views:
15
Rod,

I think it depends what you mean by "manipulation".

Lots of stuff out there provides the features of a highly scalable, customized, enhanced spreadsheet with pivot abilities. Many batch entry, financial/billing apps fall into this category. Please accept I'm not criticizing, I'm just segregating app types! IMHO the real value in such apps comes from smart UIs, business awareness and featuresets, not the precise technology used to provide the views. Clearly the market agrees- check out which "modern" technologies are used by many banks and financial institutions. When they upgrade, it won't be because their current 25-year-old technology needs better data manipulation features.

I'm more talking about scenarios where data is more based on meaning and relationships between items and collections of data rather than column values and expressions. Relationships can span dozens or even hundreds of rows in the same dataset. Artificial Intelligence is in this domain, as is some of the newer clinical care planning work.

Can it be done in C#? Yes- I should know, we did some of it starting in 2002. But we struck immediate hurdles because ADO.NET was memory resident. You say you've done some large row manips: lets be fair, they're small rows, or you had far more memory than a standard business machine, or both. And did you open a huge resultset several times with variably filtered results, index some of them, then compile a report that could be refreshed almost instantly by the user changing a parameter in their UI? If you did, I'll bet you did it at the server. We tried that too, and it brought the server to its knees with just a few users. Whereas a local VFP cursor delivered blazing performance with no network, server or PC resource hogging.

IMHO there are some things VFP is just good at. Surely we agree I need to be able to say this, just as dotNETties need to be able to say what they like about their new tool. FWIW, MS says dotNET will soon be good at the stuff that draws many of us to VFP. Excellent! If nobody spoke out, perhaps that would never happen.
"... They ne'er cared for us
yet: suffer us to famish, and their store-houses
crammed with grain; make edicts for usury, to
support usurers; repeal daily any wholesome act
established against the rich, and provide more
piercing statutes daily, to chain up and restrain
the poor. If the wars eat us not up, they will; and
there's all the love they bear us.
"
-- Shakespeare: Coriolanus, Act 1, scene 1
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform