| Subject | Re: [firebird-support] Slow at writing record cointaining BLOB fields |
|---|---|
| Author | Aage Johansen |
| Post date | 2004-12-30T13:51:49Z |
Hardy wrote:
gain from adjusting the number of buffers: if there is sufficient free RAM
on your server, try to increase the number of PageBuffers (but, keep it
less than 10000) - 10000 pages of 4096KB will need about 40MB RAM.
Maybe you should post the "Header statistics" from the database.
Maybe the speed is influenced by how your app is coded. Do you use the
BDE? Do you use "Table type" components?
--
Aage J.
>Try changing the page size to 4096 (backup+restore), and you might possibly
> Please advice what might be wrong so that database writing really slow
>
> DATABASE PAGE SIZE = 1024
>
gain from adjusting the number of buffers: if there is sufficient free RAM
on your server, try to increase the number of PageBuffers (but, keep it
less than 10000) - 10000 pages of 4096KB will need about 40MB RAM.
Maybe you should post the "Header statistics" from the database.
Maybe the speed is influenced by how your app is coded. Do you use the
BDE? Do you use "Table type" components?
--
Aage J.