We replace the file monthly (when a new DB release is done). We have an automated script that stops the SmarterStats service, downloads the new database, renames it etc. and overwrites the existing one, then starts SmarterStats.
I am not sure if the file is read constantly if it read once and loaded into memory, so we restart the service anyways. Doesnt hurt and only takes a few seconds to do.