Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

stored procedure slow

Status
Not open for further replies.
crystalReporterNew

crystalReporterNew

Programmer
Jan 18, 2004
24
US
Hi,
I have a simple SELECT query in SQL(with a LIKE clause in it) that runs very fast if called natively on the database prompt.It also runs equally fast as a stored procedure,however, after a long period of DB shutdown or logging off from the server and logging back in again the stored procedure is slow. If I drop and create the stored procedure again, it runs as fast as ever.What could it be? The query always runs fast at any time so it doesnt have anything to do with query caching.
Please help.
Thanks.
 
Sort by date Sort by votes
It might be something related to bringing the data to the adaptive server data cache.
After running it and suffering a bad performance once - have you tried running it again? have you suffer a bad performance again and again?
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

raphael75
  • Locked
  • Question
trying to call Sybase stored procedure with parameters from PHP
Replies
0
Views
112
raphael75
raphael75
cbsm
  • Locked
  • Question
procedure performance
Replies
0
Views
61
cbsm
cbsm
vipinhcl
  • Locked
  • Question
Immediate not found error when running this procedure. Please help!
Replies
1
Views
81
PDreyer
PDreyer
mandogon
  • Locked
  • Question
90 Day Procedure
Replies
0
Views
55
mandogon
mandogon
paraglidersd
  • Locked
  • Question
temp table traversal in stored procedure
Replies
1
Views
66
PDreyer
PDreyer

Part and Inventory Search

Sponsor

Back
Top