473,385 Members | 1,582 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,385 software developers and data experts.

Stored procedure is taking long time in execution while query is runing fast

1
Hi,

I am facing issue with my stored procedure it is taking very long time to execute. As i am using local variable inside the procedure. Still i am getting the issue. As, I have copied query to my query editor it is runing in milliseconds. Can you help me with issue.

Thanks
Apr 18 '18 #1
0 3039

Sign in to post your reply or Sign up for a free account.

Similar topics

4
by: madhusudan.hv | last post by:
hi, Can you tell me when an application might take long time to dump core? The linux o.s is indicating that a process is dumping core, and only after 40 mins i am seeing the core file. What might...
1
by: anandanies | last post by:
I am having a new server which has SQL 2005 standard edition SP2 installed on it (OS windows 2003 server) On migrating from SQL 2000 to SQL 2005 , I observe certain procedures taking almost 10...
4
by: resmi318 | last post by:
I am running a query similar to given below. CREATE TABLE ABC_08 AS (SELECT x.col1, trim(x.col2), x.col3, x.col4, x.col5 FROM Table1 x
0
by: kavin | last post by:
our Customer used to take export backup of a particular schema, previously it used to finish within 30 Minutes. As of now it is taking almost 12 Hours. Export is consuming more time while...
7
by: kiranrajenimbalkar | last post by:
Hi, when i am executing the below SQL its taking long time for execution so please provide me the solution. SELECT A.ID, A.IDTYPE, A.USERNAME, A.FIRSTNAME, ...
3
by: zacksoniar | last post by:
Hi guys, 1. In my application,to Connect to DB, i used to write direct string queries in any function, assigning them appropriate variables using '+' sign. Then I had separate Data Access class...
2
by: dougancil | last post by:
I have a form that requires me to execute several stored procedures one after the other. I'm wondering how to do that in vb.net. I realize that I could just have one stored procedure with all of my...
0
by: pramodds | last post by:
Hi All, I have SQL db2 stored procedure and currently on db2 9.5 version. Its federated environment where the stored proc queries certain tables in one database and loads that data in another...
2
by: osman7king | last post by:
I have a procedure which works on a collection of employees (cursor), the procedure calculates for each employee: - the number of absence days, - the salary according to the absences, - the taxes...
1
by: groverdghp | last post by:
Hi All, I am at my wits end. I would consider myself an intermediate programmer and have been managing a web application that I wrote in .ASP, VBScript, and JavaScript for years. There is one task...
0
by: taylorcarr | last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
0
by: aa123db | last post by:
Variable and constants Use var or let for variables and const fror constants. Var foo ='bar'; Let foo ='bar';const baz ='bar'; Functions function $name$ ($parameters$) { } ...
0
by: ryjfgjl | last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
0
by: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
0
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.