Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Improving sluggish SQL
Message
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00306158
Message ID:
00306376
Views:
35
>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.
Previous
Reply
Map
View

Click here to load this message in the networking platform