Hi Jeff,

A little background. The application we developed allows a user to search properties in the U.S. The user can select any area and click "view results".

Behind the scenes we have the Primary Key of the table in the middle tier and then store that in a VARBINARY column in the DB. This is working pretty well as we only pass the binary string across the wire.

We have a CLR function which we use to de-serialize this VARBINARY column to a list of EntityIDs.

The developer and I were experimenting with removing the dependency on this DB and seeing how well the app would perform if we send a table type or list of IDs to a stored proc.

Sending a table type with say 50k properties is taking much longer than expected. Our current solution as of now is faster (storing VARBINARY, then CLR to de- serialize) .

The goal of this project was to remove the dependency of the DB and our first thought was try Table Type parameter.