On 30 Dec 2004 at 14:09, Hardy wrote:

>Facts:
>============================
>We are running Firebird 1.0.0.796 around 2-3 years.
>Production Database running in relative small machine PIII 600Mhz,
>384MB memory, 20GB dedicated IDE harddisk, Win2000Pro Network speed =
>100Mhz Numbers of client to access database = 10 clients Database size
>around = 14MB BLOB fields Stores as = BLOB SUB_TYPE 0 SEGMENT SIZE 80

You didn't mention size of written BLOBs and _how_ you write them.

>The problem:
>============================
>We suffer very slow response when writing records containing BLOB
>fields (arround 30 seconds)

How many BLOB fields in the record? What component set you use?
Usage pattern?

>Questions:
>============================
>1) How to improve the database writing speed ??

Use bigger buffers. Trace your code and find out the slowest part.

>2) Any idea if FB version 1.5.2.4731 will improve speeds ??

Very little chance.

>3) From my research below the small server machine does not effect
>much on the response time. However the client machine will play a
>greater role on response time. Please advice if this situation is
>normal ??

It is normal if problem is in your application.

>4) All my BLOB fields are stores as BLOB SUB_TYPE 0 SEGMENT
>SIZE 80 .. Please advice what is the best format/way to store the BLOB
>format ??

There is only one BLOB format. Neither sub_type nor segment size
affect the way BLOBs are stored or handled.
--
SY, Dimitry Sibiryakov.