Re: 回复: Oracle 12c Inmemory - don't stop thinking

Good article Martin and very impressive results for In-Memory.

The value of in-memory, OLAP, Cube materialized views, traditional MVs, indexes, and any other form of query optimization is ensuring that your strategy is actually being effectively applied to the problem queries.


For in-memory to be effective, I'd summarize with:

1.  Unless you have unlimited memory to store everything in memory, you have to think about what to put in memory to ensure your problem queries are resolved.

  -It's nice to see that you have that kind of granular control to not include stuff you don't need.

2.  You have to have enough memory to hold the required data.  -With memory capacity in systems going up up up, caution about how we use memory will probably continue to be reduced.
 -it would be interesting to see how only partially stored objects fare in other use cases.
 

As you said:  "13s to 0.35s, that’s 37 times faster."   


That's impressive!


Job





________________________________
 From: xiangdongzou <xiangdongzou_at_gmail.com>
To: usn <usn_at_usn-it.de>; ORACLE-L <oracle-l_at_freelists.org> 
Sent: Friday, July 25, 2014 10:45 AM
Subject: 回复:  Oracle 12c Inmemory - don't stop thinking
 


yes,we will know 
everythine well. in-memory is not everything.
 
2014-07-25

________________________________
       
I AM AN ORACLE FANS!
Skype:Frank.oracle
Email:xiangdongzou_at_gmail.com

________________________________
 
发件人：Martin Klier 
<usn_at_usn-it.de>
发送时间：2014-07-25 22:38
主题：Oracle 12c Inmemory - don't 
stop thinking
收件人："ORACLE-L"<oracle-l_at_freelists.org>
抄送：
 
Dear listers, 
 
Oracle tells us that InMemory will care for everything. But as usual, 
the BUT is well covered. In my recent blog post 
 
"Oracle 12c InMemory - don't stop thinking about performance" 
http://www.usn-it.de/index.php/2014/07/25/oracle-12c-inmemory-dont-stop-thinking-about-performance/��
 
I tried to show an early and simple test case to demonstrate, that 
knowing your SQL and data model still is the prerequisite for performant 
operations. InMemory is just one more tool, not the Savior. 
 
Request for comment please! 
 
Eyes open, regards 
Martin 
 
--  
Usn's IT Blog for Oracle and Linux 
http://www.usn-it.de��
 
performing databases 
Your reliability. Our concern. 
http://www.performing-databases.com��
 
-- 
http://www.freelists.org/webpage/oracle-l��

--
http://www.freelists.org/webpage/oracle-l