I'd like to know if anyone has some stats on the various methods of storing lists of text - which are fastest, least expensive etc.
Currently I am working on a plugin which already connects to MySQL for some functions, so I have an SQLx tuple global available. I am about to write a simple function which will check nicks for bad words, and I am wondering if I should store the list of those illegal words in a text file, nVault or in an sql table.
Flat file and sql are equally easy to maintain, whilst nVault will require me to setup and use the nVault editor (or code a function to add+edit values ingame, which I am not prepared to do - but I might consider coding a function which when manually loaded reads a flat file and stores in nVault).
Are there significant differences in performance between the three, are there special scenarios where one is clearly prefferable in terms of speed and server load?
Thanks in advance, and sorry if it's in any FAQ I missed when searching. (How do you search this forum for specific phrases? It strips my quotes and +words)