Can it be made into a stored procedure so that is not being parsed by
the SQL server every time it is called?
On 10/12/2004, at 9:57 AM, Jason Schulz wrote:
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]
________________________________________________________________________
TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
