Hi Larry,
To speed up your queries, remove ALLTRIM() from the WHERE clauses and create indexes on PRO_SCHT.SPFLAG, p_number and TRANNUMBER if you dont have them yet.
BTW, SET EXACT has no effect on Sql Select command.
>Hi Folks -
>We have the following statement in our code which peforms OK on a table size of less than 10,000 records, anything greater we are running into performance issues. Can anyone advise how we could correct it:
>
>...
>select prod_tran
>set filter to
>set order to
>set exact on
>SELECT * FROM PRO_SCHT INTO CURSOR PROSCHT WHERE ALLTRIM(PRO_SCHT.SPFLAG)="*"
>SELECT 0000000000.000 AS CNTRANGE ,* FROM proscht a INTO DBF &pscht where EXISTS(SELECT * FROM PROD_TRAN b WHERE (a.p_number=b.p_number AND ALLTRIM(b.TRANNUMBER)=ALLTRIM(m.trannumber)))
>
>PSCHTA=ALIAS()
>....
>
>We need to create the &pscht as a dbf as we are continuously updating it.
>
>Thanks,
>
>Larry
--sb--