Unix Technical Forum

BYTE type in blobspace or tablespace

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 ...


Go Back   Unix Technical Forum > Database Server Software > Informix

FAQ Members List Calendar Search Today's Posts Mark Forums Read
  #1 (permalink)  
Old 04-20-2008, 05:18 PM
mohitanchlia@gmail.com
 
Posts: n/a
Default BYTE type in blobspace or tablespace

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 ?

Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Reply


Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On
Forum Jump


All times are GMT. The time now is 08:44 AM.


Powered by vBulletin® Version 3.6.5
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
SEO by vBSEO 3.2.0
www.UnixAdminTalk.com