471,337 Members | 1,141 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 471,337 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 884

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

1 post views Thread by Christian Luszick | last post: by
2 posts views Thread by p2esp | last post: by
3 posts views Thread by Fazer | last post: by
4 posts views Thread by Laphan | last post: by
5 posts views Thread by Jim in Arizona | last post: by
5 posts views Thread by wamatt | last post: by
2 posts views Thread by mircu | last post: by
2 posts views Thread by Fraijo | last post: by

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.