search

SETI / rms-opus

PDS OPUS - Outer Planets Data Search Tool
Apache License 2.0
9 stars 7 forks source link

Upgrade OPUS to use new MySQL JSONB feature #1330

Closed rfrenchseti closed 2 months ago

rfrenchseti commented 6 months ago

MySQL is adding a new JSONB feature that will allow JSON field access to be up to 3 times faster. It has not been released in production yet. When it is, we should investigate what is required to use it and if it speeds up database accesses.

https://sqlite.org/forum/forumpost/fa6f64e3dc1a5d97

rfrenchseti commented 2 months ago

This is not a MySQL feature, it's a SQLite feature, so not relevant to OPUS.