search

Xahau / xahaud

Codebase for Xahaud - The consensus, RPC & blockchain app for the Xahau network.
https://xahau.network
ISC License
23 stars 11 forks source link

Fix account_tx sluggishness #308

Open WietseWind opened 4 months ago

WietseWind commented 4 months ago

Implements fix as per https://github.com/XRPLF/rippled/commit/2e9261cb

As per Ripple Eng:

The SQLite db is not using indexes with the previous SQL, so full table scan was going on. The fh nodes has a big table so the thread is hanging I found the issue but it’s the developer who found the SQLite optimizer problem It only happens when the account has a lot of transactions and marker is used for paging

WietseWind commented 4 months ago

Already merged into jshooks; - will reach DEV branch that way too. https://github.com/Xahau/xahaud/pull/330