I have a case where the joining fields are fixed 6. The
performace is extremely slow. I originally wrote this in MSSQL2000 and it worked
reasonably, like only a couple of seconds on a slow PC. In SAP 7.4.3beta it
takes 10 seconds for 60 rows even on a speedy box.
Excerp:
SELECT patronrelations.PRIMARYPATRON,
patronrelations.SECONDARYPATRON,
patronrelations.VERIFYEXPIRATION, PATRONS.*
FROM DBO.PATRONRELATIONS patronrelations
INNER JOIN DBO.PATRONS PATRONS ON patronrelations.SECONDARYPATRON=PATRONS.PATRONID
patronrelations.SECONDARYPATRON,
patronrelations.VERIFYEXPIRATION, PATRONS.*
FROM DBO.PATRONRELATIONS patronrelations
INNER JOIN DBO.PATRONS PATRONS ON patronrelations.SECONDARYPATRON=PATRONS.PATRONID
where patronid and secondarypatron are the fixed 6 fields. Any issues
about numeric joins? I have tried adding indexes on all the joining fields which
usually improves performance greatly but not in this case.
Don Hayes
Database Administrator
Tualatin Hills Parks & Recreation District
Phone: (503) 614-1219
FAX: (503) 629-5398
Database Administrator
Tualatin Hills Parks & Recreation District
Phone: (503) 614-1219
FAX: (503) 629-5398
