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? And another question: does RDB$PAGES need to include the pagespace ID or we never allow tablespaces for TIP, generator pages and system tables? 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. Dmitry ------------------------------------------------------------------------------ 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