Hey guys I was wondering what the best conventions were for MVC type websites involving a database. Should I load everything into MySQL if the website shuts down and when it starts should I load all the data into like a BST model or should I use the database while the site is active?
Hit the database to grab data as you need to. Cache data where it makes sense.
I'm not sure what you mean with load everything into MySQL if the website shuts down. Do you mean store the users session info in the database when they leave? I don't follow there.
But again, IMO, don't load all the data. Load the data as you need is. Yes -- use the database while the site is active.