Speed of dynamic vs "normal" Excel report

[Jan Pola]

When I run the same advanced find from the CRM application versus from a
dynmic Excel I and many of our users experience significant differnce in time
it actually takes to get the data. (Were are talking 3 minutes vs. 30
minutes!)

Any idea on why this signigificant difference and what to do about it?

[LeonTribe]

Post by Jan Pola
When I run the same advanced find from the CRM application versus from a
dynmic Excel I and many of our users experience significant differnce in time
it actually takes to get the data. (Were are talking 3 minutes vs. 30
minutes!)
Any idea on why this signigificant difference and what to do about it?

The fundamental difference between the two is a dynamic worksheet has
to query the data from the CRM SQL database. My guess is the query is
holding things up. Your two obvious choices are optimising/simplifying
the query being run or optimising SQL.

Leon Tribe
Want to hear me talk about all things CRM? Check out my blog
http://leontribe.blogspot.com/
or hear me tweet @leontribe

[JWP]

Hello Leon,

thank you for your answer. Please note that I do noting special, I try to
get to the same data based on report created in the CRM application:
Exporting statically takes 3 minutes, creating a dynamic Excel (from within
the CRM application) takes same time, but when I then want to update the data
from within Excel it all of a sudden takes 30 minutes!

It seems to access the data in some different (less efficient) way and my
quesiton is really how this works and if there is anything which can be done
to speed up the dynamic Excel.

Any advice appreciated.

Post by LeonTribe

Post by Jan Pola
When I run the same advanced find from the CRM application versus from a
dynmic Excel I and many of our users experience significant differnce in time
it actually takes to get the data. (Were are talking 3 minutes vs. 30
minutes!)
Any idea on why this signigificant difference and what to do about it?

The fundamental difference between the two is a dynamic worksheet has
to query the data from the CRM SQL database. My guess is the query is
holding things up. Your two obvious choices are optimising/simplifying
the query being run or optimising SQL.
Leon Tribe
Want to hear me talk about all things CRM? Check out my blog
http://leontribe.blogspot.com/
.

[LeonTribe]

Post by JWP
Hello Leon,
thank you for your answer. Please note that I do noting special, I try to
Exporting statically takes 3 minutes, creating a dynamic Excel (from within
the CRM application) takes same time, but when I then want to update the data
from within Excel it all of a sudden takes 30 minutes!  
It seems to access the data in some different (less efficient) way and my
quesiton is really how this works and if there is anything which can be done
to speed up the dynamic Excel.
Any advice appreciated.

Post by LeonTribe

Post by Jan Pola
When I run the same advanced find from the CRM application versus from a
dynmic Excel I and many of our users experience significant differnce in time
it actually takes to get the data. (Were are talking 3 minutes vs. 30
minutes!)
Any idea on why this signigificant difference and what to do about it?

The fundamental difference between the two is a dynamic worksheet has
to query the data from the CRM SQL database. My guess is the query is
holding things up. Your two obvious choices are optimising/simplifying
the query being run or optimising SQL.
Leon Tribe
Want to hear me talk about all things CRM? Check out my blog
http://leontribe.blogspot.com/
.- Hide quoted text -

- Show quoted text -

That's quite strange behaviour. I'd run a trace on the SQL server to
see where the hold up is and looking to tweak SQL indexes.

Leon Tribe
Want to hear me talk about all things CRM? Check out my blog
http://leontribe.blogspot.com/
or hear me tweet @leontribe