At 10:49 AM 31/12/2004 +0700, you wrote:

>--- how big are the blobs?
>*** How to know the blobs size ? How to print out the blob size so that
>I know the size?
>What tools to use to print out the blobs size?

Well...you could write a query that uses the appropriate UDF from
FreeUDFLib...but really, do you have no idea of the approximate size of the
blobs you are writing into your database? They must come from somewhere...

>--- What is the database page size?
>*** I have change the page size from 1024 to 4096 then 8192. Then
>retested the application but the running time around 28 second which
>originally 30 seconds on 1024 page size. I assume page size does not
>make any different

No, it's only one of your problems. Clearly the network is the one you
have to look at most closely, since you already have stats that show the
network as the source of delays.

>============
>Notice from gbak restore function switch.
>What is -bu switch means ??

It sets the size of the page cache for the restored database. It needs an
integer (the number of buffers (pages) as a parameter. Make sure the
number * the page size is not so large that it hijacks all of your
RAM. Low RAM is one of your problems already.

>How does this switch can be used to speed up the database performance ?

It allows more pages to be cached, as long as your RAM supply is
plentiful. Again, take care with changing this, because you don't have
much RAM for 10 users.

./hb