George Kyriazis
Dabbler
- Joined
- Sep 3, 2013
- Messages
- 42
Ok, I'm trying to figure out what's the best practices for the Reporting Database settings, but I haven't found anything yet giving reasons as to why one would choose one vs another. There is a lot of documentation of "you can put your database here or there", and "do it by ...", but nothing satisfactory as to why.
So, there are 2 parameters that I see, that seem to be independent:
1. System dataset pool.
One could choose the boot pool or a data pool. Documentation says don't put in the boot pool, since it is frequently written, but one could argue that an SSD boot pool is faster, so why not put it there? What are the bottlenecks when using the boot pool?
2. Reporting database checkmark.
Documentation says that if unchecked it's put in a temp filesystem and then copied to 'on-disk' files. Um.. Is the temp filesystem not on disk, then? Which one? Why would one choose one option vs another?
Thanks for some
So, there are 2 parameters that I see, that seem to be independent:
1. System dataset pool.
One could choose the boot pool or a data pool. Documentation says don't put in the boot pool, since it is frequently written, but one could argue that an SSD boot pool is faster, so why not put it there? What are the bottlenecks when using the boot pool?
2. Reporting database checkmark.
Documentation says that if unchecked it's put in a temp filesystem and then copied to 'on-disk' files. Um.. Is the temp filesystem not on disk, then? Which one? Why would one choose one option vs another?
Thanks for some