speed up query
-
Hi I hav a problem with my stored procedure, its taking far too long. I have used simple JOIN statements, but unfortunately I have 7 tables to JOIN and therefore 6 JOIN statements in this one procedure. There is also a simple SUM calculation happening within this query as well. But this procedure is takin far too long to get the results. Was going on 18 minutes and counting when i cancelled it. :( Can anyone help me out?
-
Hi I hav a problem with my stored procedure, its taking far too long. I have used simple JOIN statements, but unfortunately I have 7 tables to JOIN and therefore 6 JOIN statements in this one procedure. There is also a simple SUM calculation happening within this query as well. But this procedure is takin far too long to get the results. Was going on 18 minutes and counting when i cancelled it. :( Can anyone help me out?
Show the code for the stored procedure, along with the database table structure/schema and someone might be able to shed some light for you.
rcwoods wrote:
Was going on 18 minutes and counting when i cancelled it.
How many records do you expect it to return?
"Find it your bloody self - immediately!" - Dave Kreskowiak
-
Show the code for the stored procedure, along with the database table structure/schema and someone might be able to shed some light for you.
rcwoods wrote:
Was going on 18 minutes and counting when i cancelled it.
How many records do you expect it to return?
"Find it your bloody self - immediately!" - Dave Kreskowiak
Thanks for the reply, I think i figured out what was wrong. It was expected to return alot of records.in the high thousands. Thanks again for reply
-
Thanks for the reply, I think i figured out what was wrong. It was expected to return alot of records.in the high thousands. Thanks again for reply
Out of curiosity, how many thousands of records? Sounds like 18+ minutes is still way too long.
"Find it your bloody self - immediately!" - Dave Kreskowiak
-
Out of curiosity, how many thousands of records? Sounds like 18+ minutes is still way too long.
"Find it your bloody self - immediately!" - Dave Kreskowiak
-
Glad you got it to work :-D
"Find it your bloody self - immediately!" - Dave Kreskowiak