> Have you tried calling the stored proc 10,000 times purely in SQL server to see whether that is a limiting factor?

I tried this in SQL Server Management studio and...

> do the 10,000 calls occur sequentially by one user or will they occur in parallel by more than one user?

It may or may not depending on how many clients...

> You still haven't explained what you're trying to do 10,000 times a second...

I thought I did.. but perhaps I didn't understand your question.

I am trying to call the Find()...

That didn't make any difference. Mainly, I am not certain it would make difference to the time taken for *inter process communication* between my C# app and SQL Server. But...

Thanks for the replies.

Set based operations - yes, that was the first thought that came to my mind as well and in fact I suggested it. But, unfortunately, for business...

Did you mean "that's the main point that's *NOT* going to allow the optimizer to use this index t find information within the system". Because if it does, shouldn't I...