I agree,
I was going to ask if he has considered putting
the query into a stored procedure
Ben Johansen - http://www.pcforge.com
Authorized Witango & MDaemon Reseller
Available for Witango Developement
From: Jason Schulz
[mailto:[EMAIL PROTECTED]
Sent: Thursday, December 09, 2004
3:57 PM
To: [EMAIL PROTECTED]
Subject: Re: [spam?] Re:
Witango-Talk: URGENT: MS-SQL hanging - processnon-yielding
Dave,
Can you tell us a little about what the query is trying to achieve, as it
should probably be re-written to optimise it a little.
Jason.
On 10/12/2004, at 8:04 AM, Dave Machin wrote:
The 150K is the size of
the query itself not the results. I've attached it.
However, even after this .taf was disabled the site became unresponsive
after about an hour. So, it may have nothing to do with it. I am worried
about the number of new database connections that get made - we seem
to average one or two per second.
WITH
IMAGINATION
Planning,
Implementation and Management of Web Applications
160 Pacific Highway
North Sydney NSW Australia 2060
phone
+ 612
9929 9229
fax +
612 9460
4770
web -
www.wi.com.au
email -
[EMAIL PROTECTED]
