<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META content="text/html; charset=us-ascii" http-equiv=Content-Type>
<META name=GENERATOR content="MSHTML 8.00.6001.18813"></HEAD>
<BODY>
<DIV><SPAN class=022211915-30092009><FONT color=#000080 size=2
face="Lucida Sans">It's simply taking SQL Server 4 seconds to generate and
return 2,000 rows. Note that in some queries the work is done at execute time,
in others, like this one, the works gets done at fetch time.</FONT></SPAN></DIV>
<DIV><SPAN class=022211915-30092009><FONT color=#000080 size=2
face="Lucida Sans"></FONT></SPAN> </DIV>
<DIV><SPAN class=022211915-30092009><FONT color=#000080 size=2
face="Lucida Sans">I don't know the particular query. Is it reasonable that the
query takes 4 seconds? Can you tune it?</FONT></SPAN></DIV>
<DIV><SPAN class=022211915-30092009><FONT color=#000080 size=2
face="Lucida Sans"></FONT></SPAN> </DIV>
<DIV><SPAN class=022211915-30092009><FONT color=#000080 size=2
face="Lucida Sans">Julian</FONT></SPAN></DIV><BR>
<BLOCKQUOTE
style="BORDER-LEFT: #000080 2px solid; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; MARGIN-RIGHT: 0px"
dir=ltr>
<DIV dir=ltr lang=en-us class=OutlookMessageHeader align=left>
<HR tabIndex=-1>
<FONT size=2 face=Tahoma><B>From:</B> mondrian-bounces@pentaho.org
[mailto:mondrian-bounces@pentaho.org] <B>On Behalf Of </B>wenjin
huang<BR><B>Sent:</B> Wednesday, September 30, 2009 7:57 AM<BR><B>To:</B>
mondrian@pentaho.org<BR><B>Subject:</B> [Mondrian] long fetch time using
sqlserver<BR></FONT><BR></DIV>
<DIV></DIV>
<DIV>Hi Everyone, </DIV>
<DIV> </DIV>
<DIV>We are using mondrian with a Microsoft SqlSever database. We noticed that
the fetch time with large return rows in the log is longer than usual. (exec
281 ms, exec+fetch 3984 ms, 2094 rows). We tested it with cmdrunner with
Mondrian 3.1.2 and 3.0.4, the fetch time is still very long. The driver
we used is jtds-1.2.jar. </DIV>
<DIV> </DIV>
<DIV>I don't know what would cause it, maybe some setttings in the
database or for the driver? Any ideas for this problem? </DIV>
<DIV> </DIV>
<DIV>Thank you for the help.</DIV>
<DIV> </DIV>
<DIV>Thanks, </DIV>
<DIV>Wenjin</DIV>
<DIV> </DIV></BLOCKQUOTE></BODY></HTML>