MySQL Community Server 5.5.43 has been released

2015-04-07 Thread Hery Ramilison
Dear MySQL users, MySQL Server 5.5.43 is a new version of the 5.5 production release of the world's most popular open source database. MySQL 5.5.43 is recommended for use on production systems. MySQL 5.5 includes several high-impact enhancements to improve the performance and scalability of the

store search result as new table in memory

2015-04-07 Thread Rajeev Prasad
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

Re: store search result as new table in memory

2015-04-07 Thread Emil Oppeln-Bronikowski
W dniu 07.04.2015 o 22:12, Rajeev Prasad pisze: 1million plus row in a table. user runs a search, gets some results. MySQL comes with query-cache, once you run your SELECT statement the results are kept in memory. Try it by running big query and then rerun it, the second time it will take

Re: store search result as new table in memory

2015-04-07 Thread shawn l.green
On 4/7/2015 4:12 PM, Rajeev Prasad wrote: 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.