Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Hi,
In our application, we have lots of problem with response time in queries.
For example, a query on 2 tables :
SELECT d0301700.Lot_Nbr, d0301000.Part_Nbr, d0301000.Part_Name ;
FROM d0301700 ;
INNER JOIN d0301000 ON d0301000.Id_PartStd = d0301700.Id_PartStd ;
WHERE d0301700.Id_Locat = 1 ;
INTO CURSOR curTemp
D0301000 => 1613 records
Part_Nbr is C(20)
Part_Name is C(80)
Index on DELETED()
Index on Id_PartStd
35 other indexes
D0301700 => 136108 records
Table Size 402MB (130 fields = 3158C)
Lot_Nbr is C(20)
Index on DELETED()
Index on Id_PartStd
Index on Id_Locat
2 other indexes
Result => 107987 records in 64 seconds !!!
Rushmore optimization (SYS(3054)) is full for the two tables.
I think that it can take less time than 64 seconds but I don't know how to reach better performance.
Can anybody help me ?
Thanks
Marc
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement