Subject | One question working with blobs |
---|---|
Author | german aracil boned |
Post date | 2003-08-25T14:11:22Z |
Hello
I bulding a file system with firebird database and files are writing
with blobs of 65535 bytes... Any problem with this size ? What is the
best size for work with blobs ?
Table estructure:
CREATE TABLE SYS_FILES_BLOB (
RIG RIG,
BLOCK RIG NOT NULL,
FILE_BLOB FILE_BLOB,
REP_RIG RIG NOT NULL
);
CREATE DOMAIN FILE_BLOB AS
BLOB SUB_TYPE 0 SEGMENT SIZE 512
Project page: http://sourceforge.net/projects/tlsystem
(It's an open source project)
thank
best regards
I bulding a file system with firebird database and files are writing
with blobs of 65535 bytes... Any problem with this size ? What is the
best size for work with blobs ?
Table estructure:
CREATE TABLE SYS_FILES_BLOB (
RIG RIG,
BLOCK RIG NOT NULL,
FILE_BLOB FILE_BLOB,
REP_RIG RIG NOT NULL
);
CREATE DOMAIN FILE_BLOB AS
BLOB SUB_TYPE 0 SEGMENT SIZE 512
Project page: http://sourceforge.net/projects/tlsystem
(It's an open source project)
thank
best regards