Moving a WordPress database from one domain to another can be quite aÂ challengingÂ task. If you would like to move a copy of a WordPress database from a production environment to a local development environment for example, you would probably like to change the domain names used in that database.
I recently wrote about Moving WordPress into RAMÂ to gain a significant performance boost. This is however a bold move and there are a lot of other things you can do to gain performance, one of them is using a newer version of MySQL (and why not take a look at Percona Server?).
There are a lot of things you can do to optimize WordPress to run as smooth as possible including optimizing Apache and MySQL, introducing cache layers and more. That is just fine, and they should be done in a production environment. In a development environment however, it is another story. Here you have the option to do radical things for radical results. Like, moving all data into RAM!