Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
ARGHH! big table killing VFP - need strategy help!
Message
From
14/08/1999 16:20:32
Mike Yearwood
Toronto, Ontario, Canada
 
 
To
14/08/1999 13:42:01
Walter Meester
HoogkarspelNetherlands
General information
Forum:
Visual FoxPro
Category:
Other
Miscellaneous
Thread ID:
00250826
Message ID:
00253785
Views:
23
Hi Walter

>>We both have different standpoints: I don't use indexes unless I really need them, keeping the performance for the most common use of the applic optimized. You add indexes because you think it might be handy and could increase performance for certain queries, but might be pulling down performance for the rest the application.<<

Agreed, but 1) the number of tags required to make a noticeable performance problem is very large (unless you build really complex index expressions).
2) its not might be handy, its more a case of adding view parameters that are required and adding indexes to support those. You make it sound like I'm indexing every field.

Adding extra tags for flexibility is good value for my customers since I don't have to bring their system down to add a tag if I "might" have missed one. We can't anticipate all uses the customer will make of the software and force a performance hit on them when we fail.

The net effect is I have few tags that go beyond absolutely necessary, and I've never had a call about performance problems.
Previous
Reply
Map
View

Click here to load this message in the networking platform