[Mondrian] long fetch time using sqlserver

[Julian Hyde]

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.
 
I don't know the particular query. Is it reasonable that the query takes 4
seconds? Can you tune it?
 
Julian


  _____  

From: mondrian-bounces at pentaho.org [mailto:mondrian-bounces at pentaho.org] On
Behalf Of wenjin huang
Sent: Wednesday, September 30, 2009 7:57 AM
To: mondrian at pentaho.org
Subject: [Mondrian] long fetch time using sqlserver


Hi Everyone, 
 
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. 
 
I don't know what would cause it, maybe some setttings in the database or
for the driver? Any ideas for this problem? 
 
Thank you for the help.
 
Thanks, 
Wenjin
 

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.pentaho.org/pipermail/mondrian/attachments/20090930/bdeb963c/attachment.html