Subject | Re: [firebird-support] Table limit |
---|---|
Author | Rodrigo Gonçalves |
Post date | 2006-03-17T21:24Z |
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
We have a table in our system that stores large images in blob fields
(we do this because storing them in the filesystem has been proven to
fail if you don't have a good sysadmin...). In this case does this
limit apply?
Regards
Rodrigo
Rodrigo Gonçalves
Mestrando em Cências da Computação - UFSC
Analista de Sistemas - Manager Systems
ICQ: 24006835
MSN: keitarobr@...
Jabber: keitarobr@...
"No programming language is perfect. There is not
even a single best language; there are only languages
well suited or perhaps poorly suited for particular
purposes."
Herbert Mayer
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.1 (MingW32)
iD8DBQFEGyjwlAf8Pd6TxoYRAtI7AJ9/pW+nf9/oJm8EYdd2Syc9WCPi1gCfTV9+
/r5/bUXS1EsH0vFECvHcCEc=
=wb5w
-----END PGP SIGNATURE-----
Hash: SHA1
We have a table in our system that stores large images in blob fields
(we do this because storing them in the filesystem has been proven to
fail if you don't have a good sysadmin...). In this case does this
limit apply?
Regards
Rodrigo
> Steve Wiser wrote:- --
>> What about blobs? Does the table size limit include space taken
> up by
>> blobs?
>>
>> -steve
>>
>>
>
> No !
>
> The blob use just a few bytes in the record to store the used
> blobid, the blob contents are stored on separated page.
>
> Not everyone reach this limit so frequently, don't be so desperate
> :-) anyway FB 2.0 is coming out, and this limit is gone.
>
> see you !
>
> -- Alexandre Benson Smith Development THOR Software e Comercial
> Ltda Santo Andre - Sao Paulo - Brazil www.thorsoftware.com.br
>
>
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
> Visit http://firebird.sourceforge.net and click the Resources item
> on the main (top) menu. Try Knowledgebase and FAQ links !
>
> Also search the knowledgebases at http://www.ibphoenix.com
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
>
>
> ----------------------------------------------------------------------
> YAHOO! GROUPS LINKS
>
> * Visit your group "firebird-support
> <http://groups.yahoo.com/group/firebird-support>" on the web.
>
> * To unsubscribe from this group, send an email to:
> firebird-support-unsubscribe@yahoogroups.com
> <mailto:firebird-support-unsubscribe@yahoogroups.com?subject=Unsubscribe>
>
>
> * Your use of Yahoo! Groups is subject to the Yahoo! Terms of
> Service <http://docs.yahoo.com/info/terms/>.
>
>
> ----------------------------------------------------------------------
>
>
Rodrigo Gonçalves
Mestrando em Cências da Computação - UFSC
Analista de Sistemas - Manager Systems
ICQ: 24006835
MSN: keitarobr@...
Jabber: keitarobr@...
"No programming language is perfect. There is not
even a single best language; there are only languages
well suited or perhaps poorly suited for particular
purposes."
Herbert Mayer
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.1 (MingW32)
iD8DBQFEGyjwlAf8Pd6TxoYRAtI7AJ9/pW+nf9/oJm8EYdd2Syc9WCPi1gCfTV9+
/r5/bUXS1EsH0vFECvHcCEc=
=wb5w
-----END PGP SIGNATURE-----