I need to save user searches in the database so that the user could see the results against those searches anytime he wants and also he can get email notifications if any new record matches their search criteria.In short, i want something like the saved search thing in http://www.immobilienscout24.de/
Here in http://www.immobilienscout24.de/ i can search properties giving different search params and can save that search.Then i have a "Saved searches" option that lists down all the saved searches with "show" option.Clicking on the "show" option displays the results against that saved search.
I thought of two solutions which are as follows:-
I want to know if there are some better solutions to save the user searches in database.Also what are the disadvantages of the above mentioned solutions.What problems i might be facing using one of the above solutions?