Large List<Film> resources problem

Hi everyone. I am working on Movie collection application.. I have "Film" class, with Name, Genre, Picture.. and few other Propertyes..and methods for saving the Film object in access database but like "oleObject", not each property at diferent columns.. example column[0]=ID(typeof (int), column[1] = Film object (serialized as byte[]) typeof (oleObject in access)) hope you understand me..
now the problem is: when i read from database like ("select * from table1"), i put all records in list... and the database for now contains few films, but in task manager my application use over 100 MB of Ram.. so is there any way to improve my application so it wont use that much resources?? i use dispose method like this
public class Film : IDisposable
{
         ... // some code
         public void Dispose()
         {
            This.Picture = null;
         }
      ..// other code..
}

i have on my mind (not to save the image in the database, but save in folder, and image location in database.. but it would lead to small database, and lot of memory usage in runtime.. so that is bad solution.. )

so any sugestion please?
Thank you wery much

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Aleksandar Ilioski17y ago
but i need all records in window "wivew all movies"....i was thinking to dispose the window with the records.. but used ram is not get low until i close the aplication.. so another bad solution..
jinge17y ago
Of course, there are ways to improve your application. When you use "select *" statement, all recoreds in the table will be selected and loaded in the memory. You can load the records on demand, that means, you can load as your application needs to display. whenever the application requries more, load the next batch of records.