When are data tables loaded into RAM?

I would also like to know about this. Does anyone know if there’s a considerable advantage to storing & retrieving the data through class variables, when compared to directly accessing them from the table?