This is a discussion on BYTE type in blobspace or tablespace within the Informix forums, part of the Database Server Software category; --> Version: IDS 10 I ran following tests: 1. simple large objects in blobspace 2. simple large objects fragmented in ...
| |||||||
| FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
| ||||
| 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 ? |