Click here to Skip to main content
15,742,655 members
Please Sign up or sign in to vote.
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?
Updated 24-Aug-11 7:05am

1 solution

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.
Share this answer
Tech Code Freak 24-Aug-11 23:24pm    
My 5!

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

CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900