Dear Friends,

I need your advice and help.

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

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

Questions:
============================
1) How to improve the database writing speed ??
2) Any idea if FB version 1.5.2.4731 will improve speeds ??
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 ??
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 ??

We have studied the response time below:
===============================
1) Test Database install on test server machine P4 2.6Ghz, 512MB,
Win2000Pro
Test Client on machine Celeron 1Ghz, 512MB, Win2000Pro
Writing BLOB fields spend = around 30 seconds

2) Test Database install on test server machine PIII 600Mhz, 384MB,
Win2000Pro
Test Client on machine Celeron 1Ghz, 512MB, Win2000Pro
Writing BLOB fields spend = around 30 seconds

3) Test Database install on test server machine PIII 600Mhz, 384MB,
Win2000Pro
Test Client on machine P4 2.6Ghz, 512MB, Win2000Pro
Writing BLOB fields spend = around 18 seconds

4) Test Database install on test server machine P4 2.6Ghz, 512MB,
Win2000Pro
Test Client on the same machine (local database access)
Writing BLOB fields spend = around 8 seconds


Regards,
Hardy LIM



[Non-text portions of this message have been removed]