i want to refine the results obtained from a search

Question

I am using sql server 2000 and asp.net with c# for making a search engine and i want to refine the results obtained from a search without making server connection again and again due to speed factor how can i make my search fast?..............how can i make sql server connection lesser?...

Answer 1

As Matthew alluded to, your two connection points are the HTTP request from the client (web browser) to the server (web server), and the connection from the web server to the sql server.

The connection from the web server to the sql server costs very little in the whole client-server-sql-server-client trip. So one would assume you are talking about the browser-to-webserver connection. Only way to avoid that is to dump the entire database (or at least the unfiltered pool of records one can query) to the browser and do your filtering client-side - which is an INCREDIBLY !!BAD!! IDEA.

So my suggestion would be to stop fretting, write the application as you normally would, and if things are looking slow when you are done then you can start looking for where the slowness is comming from - instead of trying to guess (and probably be wrong) before there's even an issue.