Performance Question - Browing a File with Filter causing Poor Performance - Clarion

On 8 Sep 2004 07:25:30 -0700, korcom@yahoo.com (Richard Kim) wrote:
>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 ?

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

Jason Berkan <jason_berkan@canada.com> wrote in message news:<6h7uj0h92e8mobtres57qfmecro4nbo3s3@4ax.com>...
> On 8 Sep 2004 07:25:30 -0700, korcom@yahoo.com (Richard Kim) wrote:
> >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 ?
>
> 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.

Jason Berkan <jason_berkan@canada.com> wrote in message news:<6h7uj0h92e8mobtres57qfmecro4nbo3s3@4ax.com>...
> On 8 Sep 2004 07:25:30 -0700, korcom@yahoo.com (Richard Kim) wrote:
> >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'.
> >
You can then use a range
> limit rather than a filter.
>
> Jason


Hi!

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?

Thanks Jude

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