General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
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
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only