Big wallet, Flushing wallet.dat is quite slow #2511

1. 
   007pig commented at 6:05 pm on April 11, 2013: none

   I have a wallet with many transactions. It’s around 200M. and each wallet flushing takes 4 seconds and blocks JSON RPC calls.

   I think it should be improved.

2. 
   sipa commented at 6:06 pm on April 11, 2013: member

   Agree, this is a problem. It will likely be fixed when we move to non-BDB wallets.
3. 
   007pig commented at 6:16 pm on April 11, 2013: none

   When will it happen do you know?
4. 
   007pig commented at 2:17 am on April 12, 2013: none

   CTxMemPool::accept() : accepted 8a01e91659 (poolsz 691) ThreadRPCServer method=move CTxMemPool::accept() : accepted 954115b276 (poolsz 692) Flushed wallet.dat 5071ms ThreadRPCServer method=getreceivedbyaddress ThreadRPCServer method=getbalance CTxMemPool::accept() : accepted 542b3860e4 (poolsz 693) ThreadRPCServer method=listtransactions Flushing wallet.dat CTxMemPool::accept() : accepted 0b274c1c36 (poolsz 694) Added 2 addresses from 68.119.78.5: 239 tried, 15033 new CTxMemPool::accept() : accepted 24ca9ce2e4 (poolsz 695) ThreadRPCServer method=move Flushed wallet.dat 4546ms

   You can see that the wallet.dat is keeping flushed and slow down everything. Can we make the flushing not so frequently? Can I increase ‘dbcache’ to speed it up?

5. 
   Diapolo commented at 2:36 pm on April 12, 2013: none

   AFAIK that Wallet flush thread was introduced by @gavinandresen the way it is currently working with Git master, perhaps we need to re-think how often the wallet is flushed, dunno not my playground ^^.
6. laanwj added the label Wallet on May 3, 2014
7. laanwj added the label Resource usage on Feb 16, 2016
8. 
   gmaxwell commented at 1:50 am on July 14, 2016: contributor

   I believe this is currently fixed in master.
9. laanwj closed this on Mar 6, 2018

   ---

10. MarcoFalke locked this on Sep 8, 2021

Contributors
007pig sipa Diapolo gmaxwell

Labels
Wallet Resource usage