G
gus bjorklund
Guest
Adding to what Tom said: These external storage devices all have complex sets of vendor specific configuration options and there are many tradeoffs that can be made. It is easy to set up a configuration that performs poorly. For example, a system that is used as a file-server has many creates and deletes of files and modifications of file metadata whereas a database server has few of those operations and is mostly doing random reads and writes to the same set of files. In these two cases, optimizing for one workload will have a deleterious effect on the other. The vendor personnel are rarely database people or database knowledgeable.
Continue reading...
Continue reading...