Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
What if
Message
De
10/04/2007 08:09:14
John Baird
Coatesville, Pennsylvanie, États-Unis
 
 
À
09/04/2007 19:56:07
Walter Meester
HoogkarspelPays-Bas
Information générale
Forum:
Visual FoxPro
Catégorie:
Autre
Titre:
Divers
Thread ID:
01213261
Message ID:
01213850
Vues:
13
>I'm going to do something I seldom would do... I'm going to appologise for my agressive stance here. I'll send you a personal reply later. From this point on I'm going to be purely technical and try to avoid emotion (if I can handle that) as much as possible.

Wow! That's the last thing I ever expected to see from you. It takes a big man to step up and apologize. Your post was also well done and thoughtful. Congratulations. I think I'll bury the hatchet, because underneath all that blustering there is a decent human being.

That aside, I did a project about 2 years ago in SQL server using Cursors and Record Oriented processing to migrate data from one database scheme to another, which involved translating and updating primary keys and foreign keys in multiple child tables. I spent a couple of weeks writing the routines which when completed and run on main database took 77 hours to complete.

I went back, rethought the process and then produced a complete set-oriented approach which when done, took less than 45 minutes to do the same thing. Its my experience, that set oriented will always outperform record-oreiented processing given the horsepower on the server to accomplish it.
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform