I was wondering whether moving the database to a different computer in the internal net could speed up a little the moodle server (freeing the web server from database work).
Has anyone experience with that?
Apart from moving the database and setting appropriate user privileges on the new machine, where do I change the database settings (host, user etc) in moodle? These are entered during installation, but I couldn't find a place to change them in the admin menus...
It is safe to edit just config.php directly?
You can edit the config.php and should work. The performances surely will increase: a good idea is installing a second 100Mbit LAN board exclusively for server to server communications.