Quote:
Originally Posted by cbk1994
Also, would there be any advantages to MySQL over SQLite (besides the extra features it brings, which are mostly irrelevant)? I assume it would be better since it's multi-threaded, but it might be harder to set up or maintain?
|
The biggest thing would requiring an external server to be up 100% of the time the NPC Server is up to provide a reliable gaming experience (or statistics, whatever you are using it for).
A positive of MySQL would be considerably faster queries, but honestly no application of databases in Graal would require anything past what SQLite offers. Regarding concurrency, SQLite does support that with the coming of v3, its ACIDity and therefore more complex locking structure. MySQL still trumps it, but really not important for Graal.
I wouldn't recommend doing this.