-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Can you post your SQL? Can't really help otherwise, dunno what your query does. Maybe some sample results...
Ben Timby Webexcellence PH: 317.423.3548 x23 TF: 800.808.6332 x23 FX: 317.423.8735 [EMAIL PROTECTED] www.webexc.com - -----Original Message----- From: Daniel Field [mailto:[EMAIL PROTECTED]] Sent: Monday, August 12, 2002 8:11 AM To: ActiveServerPages Subject: OT: Complex SQL/Stored Proc question Hi All, I have a Stored procedure that queries a SQL2k database for various items and returns a single ID for each result found. Now this work pretty well, taking about 400-500ms for each query. The problem is that I need to call this procedure up to 10 times in a go with different parameters so the time would go up to and over 5 seconds sometimes which is way to slow for what we are doing. I have tried passing all of the parameter in one go (Using a seperator and iterating through the list). If I query using a "union" or a temp table then the perfomance isnt realy any better, but if i do one query but use a large "OR" for the different parameters the perfomance is fine for what we want. The only problem with this is I need a way of matching up the original parameters with the results, I dont think this is going to be possible but anyone have any suggestions? Dan _____________________________________________________________________ This e-mail has been scanned for viruses by the WorldCom Internet Managed Scanning Service - powered by MessageLabs. For further information visit http://www.worldcom.com - --- You are currently subscribed to activeserverpages as: [EMAIL PROTECTED] To unsubscribe send a blank email to %%email.unsub%% -----BEGIN PGP SIGNATURE----- Version: PGP 7.0.4 iQA/AwUBPVit7/nby1cCm2Q8EQJRfgCg9DlPYbviJCvWO9B6Pc8CcFiGo78AoKIn ni36dTV7qwvq1IMRlUtO8rc1 =Re3a -----END PGP SIGNATURE----- --- You are currently subscribed to activeserverpages as: [email protected] To unsubscribe send a blank email to [EMAIL PROTECTED]
