Does AutoSproc Scale Well?

Question

We use AutoSproc as our DAL, not my choice, but it was there when I started working at my job. I was wondering if any one had any experience using AutoSproc with large web applications? I'm just curious if it would scale well as our application is growing and we might need to pop it into a web farm at some point.

If it doesn't scale well, what would you suggest then since there are several options out there.

Any info is greatly appreciated.

Answer 1

2 previous answers (by me)

TSQL - Parse Execution Plan to determine columns to be returned by a stored procedure

Are there any gotchas or good reasons not to use autosproc for stored procedure calls?

We're not a big shop in terms of users, but it didn't work for us.