BYTE type in blobspace or tablespace
Posted in 2007
mohitanchlia@gmail.com — — source: Usenet: comp.databases.informix
Version: IDS 10 I ran following tests: 1. simple large objects in blobspace 2. simple large objects fragmented in dbspace along with the rows. I am just trying to understand: 1. I see more benefit of using simple large objects in dbspace because it share pages with other simple large objects. But, in blobspace pages are not shared. So it can potentially waste lot of space. Am i missing something here other than the way blobpage in blobspace are logged. 2. Are there any restrictions on number of pages a dbspace can allocate for blobpages. Do they have their own tablespace ?