473,325 Members | 2,774 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,325 software developers and data experts.

Timeouts

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,

Joester
Jul 21 '05 #1
0 934

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

Similar topics

1
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...
2
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...
3
by: Fazer | last post by:
Hello, I was wondering what's the best way of setting timeouts when working with urllib2. Thanks,
4
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...
5
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...
5
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...
4
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,...
2
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...
2
by: Fraijo | last post by:
how can i disable session timeouts without affecting any program codings?
10
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...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

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.