Em 3/3/2016 04:04, Dmitry Yemanov escreveu: > 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
I think all the blobs should go to the blob tablespace, it's a common approach to create a 1:1 table just to store the blobs, preventing it to be stored inside the data pages. Any way, it could be an option when the users define the table. see you ! ------------------------------------------------------------------------------ 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
