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.
<x-tad-bigger>WITH IMAGINATION
</x-tad-bigger><x-tad-bigger>Planning, Implementation and Management of Web Applications
</x-tad-bigger><x-tad-bigger>
</x-tad-bigger><x-tad-bigger>160 Pacific Highway North Sydney NSW Australia 2060</x-tad-bigger><x-tad-bigger>
</x-tad-bigger><x-tad-bigger>phone +</x-tad-bigger><x-tad-bigger> </x-tad-bigger><x-tad-bigger>612 9929 9229</x-tad-bigger><x-tad-bigger> </x-tad-bigger><x-tad-bigger>fax +</x-tad-bigger><x-tad-bigger> </x-tad-bigger><x-tad-bigger>612 9460 4770</x-tad-bigger><x-tad-bigger>
</x-tad-bigger><x-tad-bigger>web -</x-tad-bigger><x-tad-bigger> </x-tad-bigger><x-tad-bigger> </x-tad-bigger><x-tad-bigger>email -</x-tad-bigger><x-tad-bigger> </x-tad-bigger><x-tad-bigger>[EMAIL PROTECTED]
</x-tad-bigger>
