I have a website that allows users to search stuff in my database via a web interface.
Now I have the possibility to get more such data from external sources. I also query data from remote servers by consuming web services when the user searches for something. Now I want to list search results from both the data in my database and the external data I retrieve from the web services on the webpage if a user searches for something.
I need to order all the data by price and various other properties, so I want to get the external data into my database as well, but only temporary to answer the a user's query of course (it could change on the remote server any time and thus become invalid if it is too old).
What is the best way to store the external data in a way that allows searching and ordering it quickly and easily?
A temporary table? Insert into my tables and mark records and temporary? Anything else?
Thanks for any hints,