i need your help to understand a performance /scalability problem.
I have to mantain a web-application that runs only in the society network, the application is an "approval workflow manager" and it is used also to store documents.
The framework is 4.0, the language is C#, the server is a sql2005 server
The application has about 500 users, and usually i think no more then 100 user at the same time.
I'm facing a problem with translations, the situation i found is a sql table for the translation, and in the base-page 's code behind a recoursive functions that look for every controls and change the description of the text with the one in the sql.
Well every page load so make requests for the same "string" every time,
so i decided to store the whole translation table in session
Note: the table count 3 language, less than 1000 translation so 3.000 at total.
Note 2: i'm developing right now the system to keep only the actual language so the total amount of data could become 1.000 rows
do you think that could be paintfull to store 3000 records in session with 100 users online ?
could store in Cache be a better solution ?
any other smart idea ?