In article <4161@bcstec.ca.boeing.com> rick@bcstec.ca.boeing.com (Richard Hall) writes:
>
>Why are you sorting a data table anyway? If the reason is to print it in
>reports in a sorted manner, do that IN THE REPORT using GROUPINGS! If you need
>to sort data in a table, you obviously are not using KEYS. Paradox nearly
>requires use of keys for optimum performance. Keys are the trigger to speed
>and performance in paradox. I find sorting seldom needed in a data table and I have been building Paradox applications for 5 years. Sorting defeats the
>purpose of keys and indexes and should not be used if a well designed database.
>Use of INDEXES create secondary keys which can increase searches and queries
>performances substantially. Do not use sorts, use Paradox functions for earching tables. Sorts can be used for processing ANSWER tables prior to creating graphs, but that is the ONLY reason I would sort a table...
I agree with most of your advice, but since you're acting like a flaming
nit-wit, here's a counter-flame:
Suppose I have 1000 customers, and I want to find the 10 with the most
sales. You tell me an easy way to find this without sorting. If you
can't, least you can do is leave a pile of black feathers.
