Subject | Re: Improve read speed on a database intensively written |
---|---|
Author | Sean |
Post date | 2007-06-19T16:29:28Z |
--- In firebird-support@yahoogroups.com, Alexandre Benson Smith
<iblist@...> wrote:
Database header page information:
Flags 0
Checksum 12345
Generation 22515374
Page size 16384
ODS version 10.1
Oldest transaction 22488749
Oldest active 22488750
Oldest snapshot 22488615
Next transaction 22515366
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 Jun 12, 2007 17:16:47
Attributes force write
Variable header data:
Sweep interval: 20000
*END*
<iblist@...> wrote:
>updated.
> You should have a good response even if the database are "heavily"
>Hi Alex, this is the header info. do you need more?
> The most important factor is to keep your transaction as short as
> possible, remember that reads run inside a transaction too, so open
> transaction, read the values, close transaction, open transaction,
> update/insert/delete, close transaction.
>
> Put your database statistics when you consider the select time are slow
> so we can look how you are dealing with your transactions.
>
> If you have the necessary indices and a good transaction control, your
> database should be pretty responsive.
>
> see you !
>
> --
> Alexandre Benson Smith
> Development
> THOR Software e Comercial Ltda
> Santo Andre - Sao Paulo - Brazil
> www.thorsoftware.com.br
>
Database header page information:
Flags 0
Checksum 12345
Generation 22515374
Page size 16384
ODS version 10.1
Oldest transaction 22488749
Oldest active 22488750
Oldest snapshot 22488615
Next transaction 22515366
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 Jun 12, 2007 17:16:47
Attributes force write
Variable header data:
Sweep interval: 20000
*END*