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 ?