one suggestion is - don't do it..
store the documents outside the gdb file and reference the file in the gdb
the overhead cost to store graphics and documents in blobs really needs to
be investigated before you commit to this method of storage
that said....
You'll be storing ascii so use sub-type text not binary
if you mean page size (segment size) then I'd still stick with 4096
I wouldn't bother splitting the file until the OS requires it

Alan

> -----Original Message-----
> From: H.I.S Developer [mailto:developer@...]
> Sent: Monday, 1 September 2003 3:18 PM
> To: Firebird Support
> Subject: [firebird-support] Some Basic ?s
>
>
> Hello All,
> I am developing a small document management system, in which I will be
> storing any king of document in BLOB fields.
> I don't know what will be the size of the each document, the
> total size the
> DB will grow. But I have decided to use Embedded Firebird.
> Now my main worries are:
>
> 1.Should I split the DB. If so how?
> 2.What should be the BLOB segment size? I don't know how big the documents
> that will be stored.
> 3.Any other factor which I should take in to account before
> building the DB
> and the application.
>
> This happens to be my first venture in Firebird and Delphi, I
> wish to listen
> to you experts and the start.
>
> General.
> *******
> 4.How to fetch a n th row in a table (or in a SELECT
> statement)(For Eg. The
> student whose rank is 22)
> 5.For a DB which is more than 500MB, 20 on-line users what should be the
> server RAM(We use 512 MB).
>
>
>
> Thank.
> VigneZ
>
>
>
>
> To unsubscribe from this group, send an email to:
> firebird-support-unsubscribe@yahoogroups.com
>
>
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>
>
>