We use Oracle and table spaces. We specify which drives/drive channels
hold which data/tables/indexes to optimize various OLAP/OLTP needs.
We also use firebird. We use multiple files as large multi-raid drive
arrays have problems in that the larger arrays may have multiple drives
fail faster than new drives can rebuild the raid stripe. Raid six has
allowed our acceptable limit to increase, but, it does not alter the issue
that some database systems generate far more transactional data than what
most people can conceive of. Although drive capacity is growing, the data
i/o channels that have to transfer that data have not been growing at the
same pace. When you need to suddenly generate a new drive on a
RAID5/6/50/60 system when all the drives where purchased at around the same
time/batch, you can easily see three or four drives fail on the same system
within the same time period. With smaller raids, the rebuild is well
within the safety zone of having the hot spares finish before another drive
starts to fail. So there is a maximum drive safety size (which is a factor
of the drive channel/drive controller/device block size/raid controller).
The entire reason raid 6 was developed was due to this very issue.
So our databases are spread across multiple raid arrays. If you remove
the ability to have multiple firebird database files, firebird will be
replaced by oracle or other platforms.
I like the concept of Firebird getting table spaces where we can specify
what those spaces are used for.
I would also like Firebird to keep the ability for those individual table
spaces to be held in multiple files.
regards
Dalton
On 3 March 2016 at 09:02, Vlad Khorsun <hv...@users.sourceforge.net> wrote:
> 03.03.2016 15:36, Dimitry Sibiryakov wrote:
> > 03.03.2016 13:38, Vlad Khorsun wrote:
> >>> May be transaction counters in each header written on each commit that
> change the
> >>>> tablespace can work better?
> >> This will create crazy overhead
> >
> > Yes. But aren't tablespaces considered for enterprise usage where IO
> for every
> > tablespace file is independent? In this case two writes have the same
> speed as one.
>
> If you have no better arguments, let's not create circus in every
> thread you are
> taking part.
>
> Vlad
>
>
>
> ------------------------------------------------------------------------------
> Site24x7 APM Insight: Get Deep Visibility into Application Performance
> APM + Mobile APM + RUM: Monitor 3 App instances at just $35/Month
> Monitor end-to-end web transactions and take corrective actions now
> Troubleshoot faster and improve end-user experience. Signup Now!
> http://pubads.g.doubleclick.net/gampad/clk?id=272487151&iu=/4140
> Firebird-Devel mailing list, web interface at
> https://lists.sourceforge.net/lists/listinfo/firebird-devel
>
------------------------------------------------------------------------------
Site24x7 APM Insight: Get Deep Visibility into Application Performance
APM + Mobile APM + RUM: Monitor 3 App instances at just $35/Month
Monitor end-to-end web transactions and take corrective actions now
Troubleshoot faster and improve end-user experience. Signup Now!
http://pubads.g.doubleclick.net/gampad/clk?id=272487151&iu=/4140
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
