I still cannot find which part on my writing Blob application that slows
down ?? Database file size around 13MB

Hello friends can you give me any suggestions or help ?

** I have increased the database page size from 1024 to 4096 and 8192
and re-tested the database writing speed. Result I got only 2 seconds
improvement. Initial speed was 30 second on 1024 page size

** On the application side I used "Client Dataset components" on the
client, and "Query components" on the server. I do not use "Table type"
at all. Also do not use BDE at all, we used Interbase Express 4.52
Components instead.

Here are the database header statistics for 4096 and 8192

Database header page information:
Flags 0
Checksum 12345
Generation 190
Page size 4096
ODS version 10.0
Oldest transaction 181
Oldest active 182
Oldest snapshot 182
Next transaction 183
Bumped transaction 1
Sequence number 0
Next attachment ID 0
Implementation ID 16
Shadow count 0
Page buffers 10000
Next header page 0
Database dialect 3
Creation date Dec 31, 2004 10:18:34
Attributes force write

Variable header data:
Sweep interval: 20000
*END*

Database header page information:
Flags 0
Checksum 12345
Generation 195
Page size 8192
ODS version 10.0
Oldest transaction 187
Oldest active 188
Oldest snapshot 188
Next transaction 189
Bumped transaction 1
Sequence number 0
Next attachment ID 0
Implementation ID 16
Shadow count 0
Page buffers 0
Next header page 0
Database dialect 3
Creation date Dec 31, 2004 10:26:12
Attributes force write

Variable header data:
Sweep interval: 20000
*END*
===============================================
Thanks in advance
Regards, Hardy



Sent: Thursday, 30 December, 2004 8:52 PM
To: firebird-support@yahoogroups.com
Subject: Re: [firebird-support] Slow at writing record cointaining BLOB
fields

Hardy wrote:

>
> Please advice what might be wrong so that database writing really

slow > > DATABASE PAGE SIZE = 1024 >


Try changing the page size to 4096 (backup+restore), and you might
possibly
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.





Yahoo! Groups Links