<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=Content-Type content="text/html; charset=iso-8859-1">
<STYLE type=text/css><!-- DIV {margin:0px;} --></STYLE>
<META content="MSHTML 6.00.5730.11" name=GENERATOR></HEAD>
<BODY>
<DIV dir=ltr align=left><SPAN class=575284700-13022007><FONT face=Verdana
color=#000080 size=2>Oops, just noticed that Michael had already enumerated my
option #3.</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=575284700-13022007><FONT face=Verdana
color=#000080 size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=575284700-13022007><FONT face=Verdana
color=#000080 size=2>There's no such thing as a simple feature -- for
instance, I've been working on another 'simple feature' (cache flush) for 5
months now. :)</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=575284700-13022007><FONT face=Verdana
color=#000080 size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=575284700-13022007><FONT face=Verdana
color=#000080 size=2>The simplest implementation of in-cache rollup would look
what is <EM>already in cache</EM>, but to meet Matt's objectives we would need
to go further: predict what is <EM>going to be in cache </EM>after the requests
are complete, and defer requests which can be subsumed by other
requests.</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=575284700-13022007><FONT face=Verdana
color=#000080 size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=575284700-13022007><FONT face=Verdana
color=#000080 size=2>Julian</FONT></SPAN></DIV><BR>
<BLOCKQUOTE
style="PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #000080 2px solid; MARGIN-RIGHT: 0px">
<DIV class=OutlookMessageHeader lang=en-us dir=ltr align=left>
<HR tabIndex=-1>
<FONT face=Tahoma size=2><B>From:</B> mondrian-bounces@pentaho.org
[mailto:mondrian-bounces@pentaho.org] <B>On Behalf Of </B>michael
bienstein<BR><B>Sent:</B> Friday, February 09, 2007 3:19 AM<BR><B>To:</B>
Mondrian developer mailing list<BR><B>Subject:</B> Re : Re : [Mondrian]
Multi-threading SQL execution<BR></FONT><BR></DIV>
<DIV></DIV>
<DIV
style="FONT-SIZE: 12pt; FONT-FAMILY: times new roman, new york, times, serif">
<DIV
style="FONT-SIZE: 12pt; FONT-FAMILY: times new roman,new york,times,serif">There's
actually a far simpler optimization to be done in the next release I hope that
can speed things up a lot in this regard that doesn't involve going to the
database at all: rollups from cached cells. Currently if a Cell is
requested and it is not in cache, it will be fetched from the database even if
all the cells that are needed to calculate its value *are* in the cell
cache.<BR><BR>Michael<BR></DIV></DIV><BR>
<HR SIZE=1>
Découvrez une nouvelle façon d'obtenir des réponses à toutes vos questions !
Profitez des connaissances, des opinions et des expériences des internautes
sur <A
href="http://fr.rd.yahoo.com/evt=42054/*http://fr.answers.yahoo.com">Yahoo!
Questions/Réponses</A>.</BLOCKQUOTE></BODY></HTML>