What is the limitation of the bitcoin core database in a windows machine? #4746

I'm having problems with more than 10.000 private keys , I wonder what is the limitation. What is the best practice of number of keys in bitcoin core wallet? is there a limit in database size ?

There is no hard upper limit. Although things can get slower with extreme numbers of transactions/keys, and at some point you may run out of memory. I know of someone with a wallet of 100000+ transactions, and it still works, albeit startup is very slow.

I understand that the optimum number of keys is around 1000 right ?

There is no optimum number of keys. You should try to use a new key for each transaction received and never spend from a key more than once for security and anonymity reasons, and you should probably not let your wallet get to the point where your box is falling over because you have too many transactions/keys, but the solution to that problem is a new wallet, not key reuse or fewer keys.

And anyhow: the number of keys is not what causes scaling issues, it's the number of transactions.

I calculated I have more than 50.000+ transactions and it is growing. I am afraid it is in "falling over" state.

Should I backup,cleanup and archive the wallet.dat daily ?

• I agree with TheBlueMatt from the security perspective.

Depends on what your application is doing, but, yea, stopping bitcoind, archiving the wallet, starting it again with a wallet that you created a while ago, generated a bunch of keys on, and then backed up may be best.

Thanks TheBlueMatt.