SQL Server question

[zzfive03]

I have 2 queries I run in my ASP page. They are rather long (6 seconds each). They do not rely on eachother. Is there any way I can send both requests to the SQL server and have them both run at the same time?

Example
'Run this one
SQL1 = "..."

'Run this one on a different request or therad
SQL2 = "..."

'After both return results, continue here...
. /....

 

[link9]

I would post this over in the SQL Server forum of this site. If you get a good answer (and you probably will), would you post it back over here so that we can all benefit?

I can't think of a way to do this, but would be very interested if there were such a method. My fear is that SQL Server may support it, but ASP doesn't (.NET does, though) support multi-threading, and so we might be limited there.

just some thoughts -
paul

 

[cmmrfrds]

I have not done this, but yes it is possible. Maybe somebody here will describle the syntax. It will deal with the event model on the recordset object. I recently purchased a book called Serious ADO by Rob Macdonald from amazon.com. Chapter 6 in the book is devoted to this subject and he gives quite clear explanations and examples.