Hi Need help? I do have huge data around 5 lakh rows, In

Question

Hi Need help? I do have huge data around 5 lakh rows, In

which one is json column that stores json array.

I need to search on that column

For eg if in input currency provided then based on that input it will search on that column and fetch price based on that currency.

Currently my query is taking
20 sec , i used json_table.

But i need to achieve it in faster way

#english #programming #sql

0

26.10.2024

9 ответов

1 просмотр

Himanshi Varshney Автор вопроса

Hi It’s urgent please, If anyone can help Much appreciated

0

4 дня назад

Himanshi Varshney Автор вопроса

Patrick Trabocchi
Try do search on code instead of db

Thanks @PatrickT80 Will it be more performative?

0

4 дня назад

Patrick Trabocchi

Himanshi Varshney
Thanks @PatrickT80 Will it be more performative?

Probably but i’ve no data to confirm my hypothesis; depend on use case. MySQL support sql select on json field? Postgres allow it accessing a JSON key and its content

0

4 дня назад

Himanshi Varshney Автор вопроса

Patrick Trabocchi
Probably but i’ve no data to confirm my hypothesis...

Yess there are json functions in mysql but its not that much beneficial looks like. I tried two ways 1. Created columns for json_data using json_table join then search on those column 3. Used json_extract functions and then search on those None of above is making any drastic difference.

0

4 дня назад

Patrick Trabocchi

Himanshi Varshney
Yess there are json functions in mysql but its not...

Why using JSON data to make sql operation like join?

0

4 дня назад

Rafael Dias

https://stackoverflow.com/questions/38389075/how-to-create-index-on-json-column-in-mysql

0

4 дня назад

Rafael Dias