How to make search reasults fast in asp.net

Question

0.00/5 (No votes)

See more:

I have lots of records in my my 3 tables, and I have 10 searching criteria in my form when I click on search button then data fetch from 3 tables from lots of records and put it into gridview, but for this it take too much time around 10-15 minutes. So can any body help me to minimize searching time?

Posted 24-Aug-11 6:56am

prathamesh812

Updated 24-Aug-11 7:05am

Not Active

v2

Add a Solution

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Not Active · Answer 1 · 2011-08-24T07:08:00

Solution 1

The searching is dependent on a number of factors, like what indexes you have on the tables, how many joins are being performed, it could even be IO performance on the database server.

Check the indexes, de-normalize the tables, use views. Start there.

Posted 24-Aug-11 7:08am

Not Active

Comments

Tech Code Freak 24-Aug-11 23:24pm

My 5!