Performance Question - Browing a File with Filter causing Poor Performance

Hi everyone,

I have a TPS file with a descending key.
It has about 100,000 records.
20,000 records have key range of 'X000001' thru 'X999999'.
80,000 records have key range of 'A000001' thru 'T999999'.

I want to display all records in browse list in descending order
except the records having key range of 'X000001' thru 'X999999'.
So that I have set FILTER < 'X000001'.

The problem is that it displays a empty browse screen and
populates records 5 seconds later. This is because of skipping
20,000 records (key range of 'X000001' thru 'X999999').

Anyone has a better idea ?
I am using C6.1PE. Windows 2003 Server with 2GHZ.
Workstatios is XP Pro with P4 2.4GHZ.

On 9 Sep 2004 09:48:55 -0700, jcb@kindheartenterprises.com (Jude)
wrote:
>I'm pretty new, so please forgive my ignorance, but why can't the
>existing key be used as a range similar to: 'A0000001' <= key <=
>'T9999999'? Does it make a difference that the key is a descending
>one?

The existing key can be made a range, as Richard pointed out.  My
fault for making the problem/solution more difficult than it needed to
be.

Jason

Jason Berkan <jason_berkan@canada.com> wrote in message news:<6h7uj0h92e8mobtres57qfmecro4n
bo3s3@4ax.com>...
> On 8 Sep 2004 07:25:30 -0700, korcom@yahoo.com (Richard Kim) wrote: 
>
> Create three fields in your file:
> 1. STRING(1) - 'X'
> 2. LONG - 456456
> 3. STRING(7) - 'X456456'
>
> Store what you display to the user in the third field.  Split that up
> into a string and a number and store it in the first two fields.
> Create your key on the first two fields.  You can then use a range
> limit rather than a filter.
>
> Jason

I tried Range Limit without spliting the key (Range of Values ==>
'A000001' thru 'T999999'). It works.
Thanks.

On 9 Sep 2004 09:48:55 -0700, jcb@kindheartenterprises.com (Jude)
wrote:
>I'm pretty new, so please forgive my ignorance, but why can't the
>existing key be used as a range similar to: 'A0000001' <= key <=
>'T9999999'? Does it make a difference that the key is a descending
>one?

The existing key can be made a range, as Richard pointed out.  My
fault for making the problem/solution more difficult than it needed to
be.

Jason