Benefits of multiple dbspaces

[PCollins]

Other then allowing you to use more disk space then a single dbspace will hold are there any other real-world advantages to using dbspaces?

[VolkerBarth]

Here's one Breck and I had discussed years ago: Temporarily storing bigger amounts of data in a separate dbspace, for data that is not needed for regular business cases but particular needs.

Needless to say, I chose the solution with the separate dbspace, and the added data is still in use for other particular needs, so there's that...

Nevertheless, it's still a reasonable choice for such different data.

[PCollins]

Thanks Volker, I have tried 2 additional dbspaces, one stores "audit" tables and another stores "associated documents", I was hoping I would see better performance on the main system space as more expensive read writes are happening elsewhere on the vdisks, or being able to rebuild just one dbspace rather then everything. But I suspect my expectation needs reducing

[MarkCulp]

One use of using multiple DB spaces is that you can (explicitly) put the different dbspaces (and hence tables) on different disks. Eg. You could put your daily data on an SSD and summary (long term) data on a spinning disk.

[timcheshire]

We use a separate dbspace to hold and process detailed daily records, the main dbsapce summarises this data daily and presents it to the users. The user' queries are a lot faster as they are not processing many tens of thousands of records.