Rajeev Prasad store search result as new table in memory
Apr 07, 2015; 20:12
Rajeev Prasad
store search result as new table in memory
hello Masters, 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. thank you.
Apr 07
Emil Oppeln-Bronikowski Re: store search result as new table in memory
Apr 07, 2015; 22:21
Emil Oppeln-Bronikowski
Re: store search result as new table in memory
Apr 07
shawn l.green Re: store search result as new table in memory
Apr 07, 2015; 17:31
shawn l.green
Re: store search result as new table in memory
Apr 09
Lucio Chiappetti Re: store search result as new table in memory
Apr 09, 2015; 16:58
Lucio Chiappetti
Re: store search result as new table in memory
Apr 12
Jan Steinman Re: store search result as new table in memory
Apr 12, 2015; 11:04
Jan Steinman
Re: store search result as new table in memory
Search
Lasso Programming
This site manages and broadcasts several email lists pertaining to Lasso Programming and technologies related and used by Lasso developers. Sign up today!