I found out that you could store your database values in memory, rather in file, wouldn't this improve performance on the application and the database?

Kinda like OPCode Caching.

__________________
VillageIdiot can have my babbies ;d

Yes, it would make it extremely fast. Though it would take up lots of the systems memory and probably have an effect on overall system performance. Plus every time the server shuts down you loose all the data since its RAM.

__________________

I know that, which is why PHP can just execute all data again when on execution of the script. :P

__________________
VillageIdiot can have my babbies ;d

Yes, it would speed everything up. I doubt there is any website you own though that would require such speed. If you have a query that takes a few seconds to execute, take a look at using views.

__________________
The man who comes back through the Door in the Wall will never be quite the same as the man who went out.