Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
>I couldn't get Sergey's linked coverage profiler tool to work with a coverage file generated from an .EXE so I dug through the logged code with the regular coverage profiler and uncovered the source of the problem. 3 simple SQL-Select statements which were all using left outer join. These left outer joins were plenty fast enough in single user mode but somehow turned deathly slow in a multi-user environment. I switched these 3 SQL-Select statements to inner joins and the speed immediately increased from 15 seconds to sub-second response times. In this particular instance I would prefer to use a left outer join as it satisfies my own paranoid shouldn't happen but strange things DO happen mentality that I program with.
>
>So why the huge penalty for a left outer join?
The OUTER joins want to bring in ALL record from a table - the LEFT side for a LEFT join and the RIGHT side table for a RIGHT join.
INNER, on the other hand, will only use records from a table that match (the criteria) in another table.
Précédent
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