Lazy Loading

Oct 31, 2010 at 12:03 AM

I wanted to mention that by default when you open database, all data is loaded into memory.  To avoid this behavior, you can use lazy loading.  Use method Database.Open("SomeName", "", true).  The last parameter indicates that the data for a table is only loaded when query against a table is executed for the first time.  Second parameter is the password, you can pass in empty string if you do not want to encrypt the data, which will boost performance as well.

Thanks