Decrease Query execution time.
-
Hello friends, I am facing problem since last 5-6 month in sql server in query executing it takes 10-12 mins to execute even if database is on local pc. I want to decrease it and want to make it execte withing 30-40 sec.. It is getting data of whole month with subquery of 1-30 date and each joining 3-5 tables for 300-500 persons. so any ideas.... :confused: :doh: One thing that i can do some process in background and insert fetched data to the some other table and at the time of executing above query fetch data from that table. if its possible then how can i do it?Is there any other way to solve this problem? Thanks in advance.. :) RAHUL PATEL
-
Hello friends, I am facing problem since last 5-6 month in sql server in query executing it takes 10-12 mins to execute even if database is on local pc. I want to decrease it and want to make it execte withing 30-40 sec.. It is getting data of whole month with subquery of 1-30 date and each joining 3-5 tables for 300-500 persons. so any ideas.... :confused: :doh: One thing that i can do some process in background and insert fetched data to the some other table and at the time of executing above query fetch data from that table. if its possible then how can i do it?Is there any other way to solve this problem? Thanks in advance.. :) RAHUL PATEL
-
Hello friends, I am facing problem since last 5-6 month in sql server in query executing it takes 10-12 mins to execute even if database is on local pc. I want to decrease it and want to make it execte withing 30-40 sec.. It is getting data of whole month with subquery of 1-30 date and each joining 3-5 tables for 300-500 persons. so any ideas.... :confused: :doh: One thing that i can do some process in background and insert fetched data to the some other table and at the time of executing above query fetch data from that table. if its possible then how can i do it?Is there any other way to solve this problem? Thanks in advance.. :) RAHUL PATEL
Rahul Say hiiiii wrote:
I am facing problem since last 5-6 month in sql server in query executing it takes 10-12 mins to execute even if database is on local pc.
Profile the query to see what's going on behind the scenes. It sounds like you have missing indexes there and that the query is performing table scans.
I have CDO, it's OCD with the letters in the right order; just as they ruddy well should be
Forgive your enemies - it messes with their heads
-
Hello friends, I am facing problem since last 5-6 month in sql server in query executing it takes 10-12 mins to execute even if database is on local pc. I want to decrease it and want to make it execte withing 30-40 sec.. It is getting data of whole month with subquery of 1-30 date and each joining 3-5 tables for 300-500 persons. so any ideas.... :confused: :doh: One thing that i can do some process in background and insert fetched data to the some other table and at the time of executing above query fetch data from that table. if its possible then how can i do it?Is there any other way to solve this problem? Thanks in advance.. :) RAHUL PATEL
Try to check if making use of a temp table is better than the subquery. BTW, this is a .Net forum.
The funniest thing about this particular signature is that by the time you realise it doesn't say anything it's too late to stop reading it. My latest tip/trick Visit the Hindi forum here.