This PR enriches MySqlRichStore to store block and transaction data.
In this section, I'm using MySqlBulkLoader to store updated_address data in the tx.
Genesis block has around 50,000 records of updated_addresses. And so, storing these entries during preloading took around 5 minutes with the original implementation. With bulk loading, the time has decreased to about 5 seconds.
However, I've been running into some issues bulk loading byte arrays into the table. When I just use addr.ToByteArray()here, the data is converted to a string. I'm wondering if there are other ways to bulk load byte array data. 🤔
This PR enriches
MySqlRichStore
to storeblock
andtransaction
data.In this section, I'm using MySqlBulkLoader to store
updated_address
data in the tx.Genesis block
has around 50,000 records ofupdated_addresses
. And so, storing these entries during preloading took around 5 minutes with the original implementation. With bulk loading, the time has decreased to about 5 seconds.However, I've been running into some issues bulk loading byte arrays into the table. When I just use
addr.ToByteArray()
here, the data is converted to a string. I'm wondering if there are other ways to bulk load byte array data. 🤔