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 ?
Bajoo - 11 Nov 2005 06:16 GMT
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