Home > Archive > Clarion > September 2004 > Performance Question - Browing a File with Filter causing Poor Performance
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Performance Question - Browing a File with Filter causing Poor Performance
|
|
| Richard Kim 2004-09-09, 3:55 pm |
| 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.
| |
| Jason Berkan 2004-09-09, 3:55 pm |
| 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
| |
| Richard Kim 2004-09-09, 3:55 pm |
| 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:
>
> 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:
You can then use a range[color=darkred]
> 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
| |
| Jason Berkan 2004-09-09, 8:55 pm |
| 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
|
|
|
|
|