UnrealIRCd Forums

It would be better if the users were stored in a remote MySQL database rather than on the host computer.
Anyone agree, disagree? Explain why or why not.

Storing any kind of database is always better on the host system when possible. There are very few applications or reasons when running a daemon that would be more efficient or secure by putting a database on a separate host than the host needing to read/store information in that database.

In any case though, latency will not be your friend. I'ts always faster to read/write to memory than querying a file each time. Inherently services that load user information from a flat file and "dump" information back to the file at intervals will generally see better performance than querying a db/file for each record, making the db remote makes it even slower. One should be careful when choosing which method as some applications that shall remain anonymous will hang until the task is complete, which can cause desyncs between services, crashes and ping timeouts of daemons.