store search result as new table in memory
- Date: Tue, 7 Apr 2015 20:12:09 +0000 (UTC)
- From: Rajeev Prasad <rp.neuli@xxxxxxxxx>
- Subject: store search result as new table in memory
I am a novice, and I am wanting to know how to achieve this:
1million plus row in a table.
user runs a search, gets some results. I want to store this result in memory in a way, so that user can fire more SQL searches on this result. How is this done? I want this to go atleast upto 20 levels down.
in addition, lets say when I am 4th level down, can I have the previous levels intact for making fresh searches on them?
I also want to store some queries, which produce level X result, in a manner that it speeds the process in future (user do not have to make multiple searches to get to the result)
initial Table||---1st search run on initial table (level 1) | |-----2nd search run on previously obtained result rows (level 2)
any help is highly appreciated.