473,387 Members | 1,502 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,387 software developers and data experts.


Hi, I have a weird problem I was hoping someone could shed some light on.

Currently I have a .aspx search screen on a webserver (4 cpu) that acesses
an sql database on our database server (4 cpu). It is used to search for
people in the database.

The problem is, on a query of say 's' for a last name, the search will union
on a number of different searches one of them being '%s%' which brings back a
rather large set of rows using a data reader. From there, we do relevance
processing, listing the person's brought back in order of greatest relevance
to search criteria.

On a rather large search like this, the database server does not seem to be
impacted much, but the webserver is hit hard. All other concurrent users
notice an immediate impact. Also, once the person that executed the original
query closes the browser without using the logout button, the server is still
affected for about 20 minutes. All of the timeouts on sessions, and ADO
commands have been left as default.

Any ideas why there is such an impact?

Also, what is responsible for killing the session on the server when a
person closes the browser? is there a way of explicitly enforcing this?
Would a dataset have less impact?

Any help is greatly appreciated,

Jul 21 '05 #1
0 936

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

by: Christian Luszick | last post by:
hi, I am using output buffering with ob_start and a callback function, which replaces variables like "%var%" with the equivilants taken out of a mysql database. This works well! But I get...
by: p2esp | last post by:
Hello, I'm using the xmlrpclib module to contact an XMLRPC server that takes a long time to send results back. My client timeouts. The question is whether there is a way to have an xmlrpclib...
by: Fazer | last post by:
Hello, I was wondering what's the best way of setting timeouts when working with urllib2. Thanks,
by: Laphan | last post by:
Hi Guys I've been using text files for Tab-Delimited/ADO/ASP sites so that users can update and display their products lists through my system with relative ease. Only problem is that for the...
by: Jim in Arizona | last post by:
I'm doing a query on a webproxy log, which is a pretty large table. I'm only doing a query on a single days worth, but could be upwards of 250000 records. Originally I got a timeout error saying to...
by: wamatt | last post by:
Subject: SQL server job timeouts? We have a job that uses WinHTTP inside a stored procedure. We have another SP wrapper that runs this for a couple hundred records. When we add this as a job...
by: zmcelrath87 | last post by:
I am having a problem involving the scope of timeouts and intervals. Since timeouts and intervals execute in the global scope, dynamically generated local interval/timeout declarations do not work,...
by: mircu | last post by:
Hi, I need a quick solution to make my application behave correctly when one of these timeouts occurs. I have some logic in session_start but when the authentication cookie timeouts the user is...
by: Fraijo | last post by:
how can i disable session timeouts without affecting any program codings?
by: Zytan | last post by:
I have a TcpClient. I set the read/write timeouts at 1 minute (in milliseconds). I get a NetworkStream from it and confirm the timeouts still exist. I do a NetworkStream.Write() and then a...
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
by: ryjfgjl | last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
by: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.