Consultor Eletrônico



Kbase P80527: Bad performance reading records with SQL query
Autor   Progress Software Corporation - Progress
Acesso   Público
Publicação   21/06/2004
Status: Unverified

SYMPTOM(s):

Bad performance reading records with SQL query

Full scan of table reads 100 records/sec

Reading records from a large table with 150 fields

When doing a SELECT from only 2 tables the speed is 8000 rec/sec

FIX:

No fixavailable at this moment