I have created a simple application that works well except for one thing. My application accesses a sql database that is quite large and what happens is that when I run my application, it wants to cache or get all the data from the database upon loading the form. How I know this is that when I first ran my app, it took so long for the form to open that I thought it was locked up, so I ended task. But then tried again, and I watch the performance tab (task manager) and notice that it was getting lots of data and putting it in virtual memory. My ultimate goal is to just access the database and pull only the records that the user request. The user would input a account number, then return me the record I wish to see. Again, all works great except for this caching issue. Help greatly appreciated.
