03.03.2016 9:04, Dmitry Yemanov wrote: > 03.03.2016 09:48, Dmitry Yemanov wrote: >> >>> Blobs could be moved into separate tablespace. It could make backup of >>> "data" tablespace faster and smaller. We can even think about "offline" >>> tablespace. >> >> Really good idea. Maybe more important for an average FB user than the >> other usage cases. > > BTW, if blob is declared as belonging to some tablespace, should level-0 > blobs be also moved to its own tablespace or stored in the table tablespace?
It depends on how we going to support tablespace for blobs. At first look it could be an option in CREATE\ALTER TABLE statement and we could define exact behavior there (if needed). > And another question: does RDB$PAGES need to include the pagespace ID or > we never allow tablespaces for TIP, generator pages and system tables? I think all system data should reside at system (default) tablespace. > Pagespace ID for PP/IRP can be retrieved from RDB$ tables based on > relation_id, so I don't see a problem to store just the "local" page number. Agree Regards, 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
