[thelist] Query Execution Time Excel vs. SRS/SQL Server

[Lee kowalkowski]

On 28/04/06, Rob Smith <rob.smith at lexjet.com> wrote:
> Is there a reason why Excel can churn out a pretty complex query in a
> matter of seconds, when the same query run in SRS or SQL Server 2005
> would take several minutes?

In addition to Richards reasons, Excel is likely to hold all your data
in memory compared to a typical database doing disk access.  There are
many in-memory database products around.  I would have thought a DB
like SQL Server would have an in-memory option.

--
LK