On Wed, Sep 3, 2008 at 11:18 PM, Teträm Corp <[EMAIL PROTECTED]> wrote:
> sorry if it's a dumb question but what is the relationship between page
> size and the maximum size of a blob ?
The blob is stored in this way (simplified - look at ibphoenix.com or
firebirdsql.org for detailed description).
1. If it's small enough to fit page size, place it there.
2. If not, use data page as pool of links to another pages and place
blob to these pages. You can imagime this as a tree, where root is
first data page with links and leafs are pages with data. It's root ->
leafs.
3. If this isn't enough do another level. Which means, first page will
contain links to pages with links to pages with data. It's a tree with
root -> nodes -> leafs.
4. Maximum number of levels is 3 (levels are 0, 1, 2).
With this, you can compute maximum blob size (taking into account some
overhead of padding on pages etc.).
Your computation (32G) takes page size 8kB for computation. For
smaller one it's:
1kB => 64M
2kB => 512M
4kB => 4G
With 8kB page and using maximum blob size you'll have more likely
problems with file system than with server. ;)
--
Jiri {x2} Cincura (CTO x2develop.com)
http://blog.vyvojar.cz/jirka/ | http://www.ID3renamer.com
-------------------------------------------------------------------------
This SF.Net email is sponsored by the Moblin Your Move Developer's challenge
Build the coolest Linux based applications with Moblin SDK & win great prizes
Grand prize is a trip for two to an Open Source event anywhere in the world
http://moblin-contest.org/redirect.php?banner_id=100&url=/
_______________________________________________
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
