Import few data fields or complete fields from SQL?

Hello,

My SQL database has 100 data columns. Is it a good manner to import just few fields ( 5 approx ) for just the Search bar implementation or dump all data from SQL database to also use all related info for specific product along with search functionality ?

In simple terms -
1.Import few fields from SQL to ES to implement search functionalities and call rest of data from other API endpoint
2.import all fields from SQL to ES to implement search functionalities and and get the rest of data from ES itself

which is the best approach ?

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.