search

tupui / soroban-versioning

Tansu - Soroban Versioning
https://tansu.dev
Other
3 stars 0 forks source link

Refactor DB schema to use indexes #8

Closed tupui closed 1 month ago

tupui commented 1 month ago

Indexing a JSON table is not optimal, hence change the schema to have multiple columns and have an index.

See here for considerations https://www.postgresql.org/docs/current/indexes-bitmap-scans.html

tupui commented 1 month ago

Also update guide in the Stellar-doc to reflect that.

Double check that the order of topics is guaranteed

tupui commented 1 month ago

Done in 80c55cf1197d162832aa768679432bf8aeb2e9b3