Hi John,
>
>Table Name: Member
>
>Fields:
>
>1. Card_No
>2. Name
>3. Address
>4. Zip Code
>...
>
>Indexes:
>1. PCard_No Card_No Primary
>2. Card_Type LEFT(Card_No, 3) Regular
>3. Card_No Card_No Regular
>
>SQL:
>SELECT Card_no, Name, Address ;
>FROM Member ;
>WHERE LEFT(Card_NO, 3) = tcCardType ;
>INTO CURSOR mymember
>
>
>The SQL above will return 5,000 records out of 10,000 records from server.
>
>I tried to issue SYS(3024), it tell me it partial optimization (since i SET DELETED ON).
>Any ideas?
Everything seems fine (except you seem to have two indixes for cardno (is the primary filtered on deleted() ?).
It seems to me that since there is such a big difference between the 10 full and 100 full setting, it is a network issue. Since the whole table is about 2Mb ++, it should take about 2 a 3 seconds to drag the whole table accross the network. Since half of the table was returned (with the help of the index) it should take about 1 a 2 seconds. On a 100 mb network the whole action should take only a fraction of a second.
Maybe the cause lies in your index file (corruption). Just drop all indexes and recreate them.
Else I'm afraid the cause could be in the hardware or network settings. Is there any anti virus software active, how is the serverload? Is this performance the same on all workstations ?
Walter,