Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Speed Difference
Message
From
08/01/2002 15:12:40
 
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00601821
Message ID:
00602172
Views:
32
Okay, I see your point. But I'm still biased in favor of using a view *grin*

>>Again, going back to the original question, he asked if a view would be faster. I threw in parameterized for free, but also mentioned query (referring to a SELECT) statement.
>
>Yep, but the solution is quite different : have an index;
>
>Now is it really so that for future we all should have views in order to make things faster ? Oh, for not too large files maybe ?
>
>He was having a response of 1-2 seconds on a "skip" with his filter. Have an index and the response will be 0,01 (when other environmental things are right); Maybe the view could make it faster, but I won't do the effort.
>
>No offence ment and no offence taken.
Steve Gibson
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform