Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Improving sluggish SQL
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
00306158
Message ID:
00306376
Vues:
36
>Walter,
>
>The problem with your suggested code is this;
>
>
>USE TABLE1 && Opens table1 in the currently selected work area
>
>USE TABLE2 ORDER TAG keyfieldTag && Opens table2 in the currently selected
>                                 && work are closing Tbale1
>
>SET RELATION TO Keyfield INTO Table2 && Sets a relation from the currently
>                                     && selected work are into Table2 whihc is
>                                     && open in the currently selected work area
>
>BROWSE NORMAL FOR EOF("Table2")
>
I understood the idea well enough to get it working with a patch or two, but ran into a dead end at the BROWSE. The COPY TO after this was extremely slow - worse than the basic SQL method I was first trying...but for just BROWsing the data, it was a good idea...
The Anonymous Bureaucrat,
and frankly, quite content not to be
a member of either major US political party.
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform