>> This may destroy the ability to use connection pooling. Then each user will have there
>> own connections, increasing resources on the both the db server and web (or app) server.
>> Scalability and performance of your site will likely decrease. Or, if connection pooling still
>> works when using context_info, then you will run the risk of having the Context_info reset
>> on the connection, or being used by the wrong user. In an ASP app, there is no guarantee
>> that you will get the same connection each time. And, other users will share the same
>> connection.
Serving the Multilingual data with concept of ContextInfo technique does not destroy the ability of Connection Poolling. The extra overhead which comes is that every command has to precede with a Set ContextInfo call based on the User's context.
The connection Reset will not hamper the logic as the next call to the DB will precede again with a SetContextInfo call and hence different Users can share the same connection.