Dear Professional,

I am working on trading environment and I am working on SQL Server 2005 at
the backend and application designed on C++. Since this is trading
environment and I am pretty much worry about performance when simultaneous
user authenticate, what would be best practice, I talked to one of the
developer and he said to call one stored procedure in the morning and grap
all the users in to memory so they don't need to call database every time,
please advice what would be the good solution

Thanks