Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Very Poor Performance of SQL on Local Table
Message
From
12/02/2002 14:57:00
Jay Johengen
Altamahaw-Ossipee, North Carolina, United States
 
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00618884
Message ID:
00619054
Views:
19
>You may want to have the table already opened and/or limit the fields that are retrieved.

Hey Doug,

Looking at it I think this is the way for me to go. I'll have to revamp a couple things to make it work and do the query the way I need. You have a good idea; if I open with either NoData or a limited number of records it should be pretty quick. I know I should have thought of something like this at the data modeling stage, but it just got lost through the cracks...

Thanks!

Renoir
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform