The stored procedure has 3 parameters, the first is a float number, the second and third are both integers. The stored procdure at most will return 25000 rows.
-----Original Message----- From: Corey L Bokowski [mailto:[EMAIL PROTECTED]] Sent: Monday, October 07, 2002 2:30 PM To: ActiveServerPages Subject: RE: SQL Query runs way faster in Query Window then as Stored Procedure It may have something to do with parameters. What if any data type are the parameters? -----Original Message----- From: Steve Abaffy [mailto:[EMAIL PROTECTED]] Sent: Monday, October 07, 2002 2:23 PM To: ActiveServerPages Subject: OT: SQL Query runs way faster in Query Window then as Stored Procedure Hello, I was just wondering if anybody knew why the exact same piece of SQL would run faster in the Query Analyzer window than it does as a stored procdure. I mean in the query window it takes 10 seconds and as a stored procedure it takes 9 minutes and 21 seconds????? Any help in this are would be greatly appreciated. --- You are currently subscribed to activeserverpages as: [EMAIL PROTECTED] To unsubscribe send a blank email to %%email.unsub%% --- You are currently subscribed to activeserverpages as: [EMAIL PROTECTED] To unsubscribe send a blank email to %%email.unsub%% --- You are currently subscribed to activeserverpages as: [email protected] To unsubscribe send a blank email to [EMAIL PROTECTED]
