Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
HomeAnnouncementsFree MagazinesWhite PapersSubmit Content
Discussion GroupsASP.NETWindows FormsLanguages.NET FrameworkVisual Studio.NET
Articles.NET FrameworkASP.NETToolsWindows Forms
.NET DirectoryOpen Source ProjectsUser GroupsWeb Resources
Related Topics
Visual Basic 6SQL ServerMS AccessOther DB ProductsMS Server ProductsMore Topics ...

.NET Forum / Windows Forms / Design Time / November 2005

Tip: Looking for answers? Try searching our database.

question about very basic scenario

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Kenny M. - 08 Nov 2005 17:48 GMT
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

Free Magazines

Get these publications absolutely FREE for up to 12 months. There are no hidden fees and no obligation. Simply choose a title, complete the application form and submit it. Read more ...

Oracle MagazineNetwork ComputingComputer WorldBio-IT WorldeWeekInformation WeekInfosecurity
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.