all groups > dotnet windows forms designtime > november 2005 >
You're in the

dotnet windows forms designtime

group:

question about very basic scenario


question about very basic scenario Kenny M.
11/8/2005 9:48:02 AM
dotnet windows forms designtime:
I have several records on my DB

Name LastName Age Address StartTime
...
...
...

I need to use that information each moment in my app though the whole day. I
mean every minute or less I need to read info about specific record


I would like to make just one access to the DB when the app start and store
all those record somewhere in memory in order to avoid going to the DB to
look info about the records. I think going to the DB each moment is not good
for performance

My question is:

What is the best practice in this scenario?

Is it OK to go to the DB thousand of times per hour, even the app and the DB
are local?

What is the appropiate structure to store all that info in memory and to be
available as soon as I need it ?


Re: question about very basic scenario Bajoo
11/10/2005 10:16:12 PM
AoA kenny,
You can use a framework/Library for Caching the data so
it will handle the performence Issue for you.

Regards,
Naveed Ahmad Bajwa
AddThis Social Bookmark Button