I have a database built on SQL Server 2017 for a matrimonial website. It has few hundreds of tables where user profile properties, partner preferences etc. are stored.
The current context is to implement search functionality on the website. Users can select the search criteria like Age (range), Height (range), Country (multi-select), Religion (multi-select), Education, Profession etc. and click on SEARCH button.
This information (user properties) is stored in tens of tables in the database and joining and applying the search conditions on these tables i.e the stored procedure is taking time to execute and return the required result set.
Any other thoughts to implement Search on such matrimonial sites where data is stored in RDBMS? Is elastic search useful in this case? How Search is implemented in popular matrimonial websites?
<button aria-label="down vote" aria-pressed="false" class="js-vote-down-btn grid--cell s-btn s-btn__unset c-pointer" data-selected-classes="fc-theme-primary" style="margin:2px;box-sizing:inherit;font:unset;cursor:default;display:inline-block;padding:0px;border:none;border-radius:0px;background:none;outline:none;text-align:center;text-decoration:none;color:unset;box-shadow:none;"
title="This question does not show any research effort; it is unclear or not useful"></button><button aria-label="favorite" aria-pressed="false" class="js-favorite-btn s-btn s-btn__unset c-pointer py4 js-gps-track"
data-gps-track="post.click({ item: 1, priv: 7, post_type: 1 })" data-selected-classes="fc-yellow-600" style="margin:0px;box-sizing:inherit;font:unset;padding:0px;cursor:default;display:inline-block;border:none;border-radius:0px;background:none;outline:none;text-align:center;text-decoration:none;color:unset;box-shadow:none;"
title="Click to mark as favorite question (click again to undo)"></button>
