TalkPHP - MEMORY engine

TalkPHP (http://www.talkphp.com/forums.php)

- MySQL & Databases (http://www.talkphp.com/mysql-databases/)

- - MEMORY engine (http://www.talkphp.com/mysql-databases/3915-memory-engine.html)

Orc	01-26-2009 06:13 PM

MEMORY engine

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.

Village Idiot

01-26-2009 06:27 PM

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.

Orc	01-26-2009 06:51 PM

Quote:

Originally Posted by Village Idiot (Post 21433)

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

Wildhoney

01-26-2009 09:48 PM

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.

All times are GMT. The time now is 02:54 AM.