Optimize merkle path query

EspressoSystems / hotshot-query-service

Generic query service for HotShot applications

https://espressosystems.github.io/hotshot-query-service/

GNU General Public License v3.0

5 stars 1 forks source link

Optimize merkle path query #570

Closed imabdulbasit closed 5 months ago

imabdulbasit commented 5 months ago

Closes https://github.com/EspressoSystems/hotshot-query-service/issues/569

This PR:

Individual queries combined with a UNION operation are significantly faster and less expensive to execute compared to queries using the LTREE operation.

Removes LTREE
Batch insert children hashes and node hashes in one query

This PR does not:

Key places to review:

src/data_source/storage/sql.rs