That's ok, now I just have to solve the problem. -----Original Message----- From: Matthew Small [mailto:[EMAIL PROTECTED]] Sent: Monday, October 07, 2002 3:11 PM To: ActiveServerPages Subject: RE: SQL Query runs way faster in Query Window then as Stored Procedure
Sorry, I misunderstood your question. Matthew Small IT Supervisor Showstopper National Dance Competitions 3660 Old Kings Hwy Murrells Inlet, SC 29576 843-357-1847 http://www.showstopperonline.com -----Original Message----- From: Steve Abaffy [mailto:[EMAIL PROTECTED]] Sent: Monday, October 07, 2002 4:06 PM To: ActiveServerPages Subject: RE: SQL Query runs way faster in Query Window then as Stored Procedure If I paste the code for the stored procedure in the query window it runs in 10 secs. If from the query window I say execute sp parm1,parm2,parm3 it then takes over 9 minutes. So I would think that the number of rows returned over the network does not impact this problem. -----Original Message----- From: Matthew Small [mailto:[EMAIL PROTECTED]] Sent: Monday, October 07, 2002 2:59 PM To: ActiveServerPages Subject: RE: SQL Query runs way faster in Query Window then as Stored Procedure I'm thining it might have something to do with the 25000 rows that are returned. That sounds like it could be quite bit of data that has to be returned over the network. Matthew Small IT Supervisor Showstopper National Dance Competitions 3660 Old Kings Hwy Murrells Inlet, SC 29576 843-357-1847 http://www.showstopperonline.com -----Original Message----- From: Steve Abaffy [mailto:[EMAIL PROTECTED]] Sent: Monday, October 07, 2002 3:37 PM To: ActiveServerPages Subject: RE: SQL Query runs way faster in Query Window then as Stored Procedure 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.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.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]
