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!

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

Store procedure freeze when enter different value

Status
Not open for further replies.

fredong

IS-IT--Management
Sep 19, 2001
332
US
I am using SQL Anywhere 9.0. I have a store procedure that has 5 parameters. Each time when I enter a value of a parameter it took 16 seconds however, when I tried to enter a different value on the same parameter it took 20 mins up. Is there way to trace the input and output or which table is the proc hitting? Any ideas? Thanks.

For example

Store procedure
----------------
Agingproc '08/20/06', 'TTT',NULL,NULL,NULL --works fine took only 16 secs

Agingproc '08/20/06', 'SSS',NULL,NULL,NULL --it took 20 mins to bring it up
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top