Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
UT Premier Discount -VFPConversion Seminar - Feb 16, 17
Message
De
08/02/2005 16:14:35
John Ryan
Captain-Cooker Appreciation Society
Taumata Whakatangi ..., Nouvelle Zélande
 
Information générale
Forum:
Visual FoxPro
Catégorie:
Conférences & événements
Divers
Thread ID:
00983141
Message ID:
00984911
Vues:
28
>>there are other ways to solve big data crunching problems as any SQL Admin will tell you. Doing processing on the server instead of relying extensively on client side processing is one thing.

I think most people here are aware of the fact that SP makes really good sense with "modern" tools. What I see is that some people are turning necessity into virtue. Local processing is too difficult with their chosen tool, which confirms that central processing is always better. Which is why VFP's local processing advantage is irrelevant. I see the same thing when mySQL people say that Stored Procedures aren't that relevant... an easy argument when one has decided that mySQL is "the best" and does not offer Stored Procedures. ;-)

>>Not using DataSets to pull large amounts of data back for display or manipulation is another as DataSets do horribly with large amounts of data because they are essentially memory based structures (collections).

Exactly. If it were always possible to avoid large local datasets, I'd agree with you. But when it comes to heavy processing involving huge static lookups, the automatic disk spanning ability of a lousy VFP table or cursor can save the customer $100,000 worth of server. Those lookups perform almost instantly, right there on the target machine without any network access or impingement on anybody else. Sure it could be done with a SP. But get a whole gaggle doing it, and just like Billy-Bob said over on the wiki- "SQL Server performs better than VFP because if it doesn't, you can buy a bigger server". ;-)
"... 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
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform