Re: Call to database causes subsequent calls to be slow

From: Adam Machanic (amachanic_at_air-worldwide.nospamallowed.com)
Date: 04/26/04 

Date: Mon, 26 Apr 2004 11:40:38 -0400

So you're saying that actually reading the data is only a bit slower, but
what happens AFTER you read the data becomes much slower?

'Time between calls increases" -- have you profiled what the application is
doing between these calls? I can think of no reason that the rate at which
you can establish a connection to SQL Server would slow down due to having
read from one database vs. another...

"Mark Powell" <markpowell.zenith@btinternet.com> wrote in message
news:ew$hkE6KEHA.2236@TK2MSFTNGP09.phx.gbl...
>
> Thanks for your reply, but I think you're missing my point. I would
> expect the reading from the historical database to be slower than
> reading from the active one, but in reality it isn't due to good
> indexing and a fast server. What does happen though is that if the data
> is read from the historical database everything that we do after that
> within the same transaction runs slowly. The code that is run after the
> read is essentially identical (same database and everything) regardless
> of which of the two the data is originally read from. The actual calls
> to SQL Server SPs run in the same amount of time regardless of the
> source data, but the time between calls increases as if it's struggling
> to establish connections or somesuch.
>

Relevant Pages

  • Re: Slowing down
    ... I know at least two writers who still do their first drafts in longhand ... writers, is a good bit slower than they read, and sometimes slower than they ... on a word-by-word level. ... in dialog that read OK when you're reading, ...
    (rec.arts.sf.composition)
  • Re: parsing a file..
    ... told that reading the file in ascii would be a slower way to do it and ... so i need to resort to binary by reading it in large chunks. ... I could parse 2000 lines in hardly any time and there was no problem ... will be slower because of needing to parse and ...
    (comp.lang.c)
  • Re: Diane C
    ... I am really enjoying it. ... It is going slower than I would like, ... been doing alot of typing lately and not enough reading so it is going to ...
    (alt.support.arthritis)
  • Re: Evanovich, Paretsky, and gabaldon
    ... >> you just need to read slower. ... you're the fastest reader i've ever ... so I spend half the next reading trying to ...
    (alt.support.arthritis)
  • Re: Call to database causes subsequent calls to be slow
    ... expect the reading from the historical database to be slower than ... to SQL Server SPs run in the same amount of time regardless of the ...
    (microsoft.public.sqlserver.programming)
Quantcast