Re: Weird speed problem
On Wed, 24 Oct 2007 22:13:11 -0700, DBMonitor wrote:
Does anyone know of a reason why there would be such a difference in
query speed?
Hi DBMonitor,
In addition to the suggestion posted by Roy, have you considered that
this may be caused by cachhing? In other words, if you run the second
query first and the first query last, or if you run both queries
repeatedly, does that change anything to the execution time?
--
Hugo Kornelis, SQL Server MVP
My SQL Server blog:
http://sqlblog.com/blogs/hugo_kornelis
.
Relevant Pages
- Re: CONTAINS performance
... That said, and with the query plan, I can start to give you more ... relational join in the context of the free-text optimization, ... SQL Server tables. ...
(microsoft.public.sqlserver.fulltext) - Re: Indexing Service, Openquery and sp_executesql
... SQL Server version and sp are you running? ... > data from the indexing service catalog when pasted into ... > query analyzer, but failed when put against sp_executesql ... I would choose Microsoft Indexing ...
(microsoft.public.sqlserver.fulltext) - Re: Problem using Access or Query Designer to run queries in SQL Serve
... >or Query Designer within Enterprise Manager, it works and I get data back. ... >ODBC Call Failed [ODBC SQL Server Driver] Timeout Expirederror in Access ... >[ODBC SQL Server Driver] Timeout Expired ...
(microsoft.public.sqlserver.odbc) - Re: Transaction Isolation Level
... This means that while I initiate a transaction selecting all new orders it ... My query is executed on a SQL server 2005. ... the isolation level you should use is snapshot isolation. ...
(comp.databases.ms-sqlserver) - Extreme performance issues (SQL Server 2000/ADO.NET/C#)
... This process runs very quickly if run through Query ... same exact stored procedures and views, run in the same exact order, through ... system that runs SQL Server (a 4-cpu Xeons system with 2gigs of physical ... When I execute these steps manually through query analyser,, ...
(microsoft.public.dotnet.framework.adonet) |
|
