how to make my searching run faster in c#.net

Question

0.00/5 (No votes)

See more:

I am using MS access as my database.I have a table with 20k records of customer and i wanna do universal search i.e when user tries to enter any text on textbox it should search in all columns of database table(i have more then 10 columns) and display result to gridview very fast,but its not happening.It takes more time then expected...can any one suggest me solution on this ?

Posted 12-Jul-12 21:27pm

Phionix11

Add a Solution

4 solutions

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)

E.F. Nijboer · Answer 1 · 2012-07-12T22:03:00

Solution 1

ms access isn't capable (including text-search). The best way to go would be to move to sql server express edition.

Otherwise just export the table as csv and do a text search on that. Its ugly, error prone and more work, but well... that's ms access...

Good luck!

Posted 12-Jul-12 22:03pm

E.F. Nijboer

Mehdi Gholam · Answer 2 · 2012-07-12T22:05:00

Searching is usually done with Lucene : http://lucene.apache.org/core/[^]

You can also use my article : hOOt - full text search engine[^]

What you must be aware of is that it will take time to index the data to save time in searching for data, and also in the context of database rows you must take deleted rows into account in your searches.

Sunny_Kumar_ · Answer 3 · 2012-07-12T22:38:00

Solution 3

I would suggest you to switching on MySQL server. its open source, reliable to suit your need and the best part is that it provides "FULLTEXT" search, which will let you search any information in your table.

Posted 12-Jul-12 22:38pm

Sunny_Kumar_

zhxhdean · Answer 4 · 2012-07-12T22:40:00

Solution 4

1.change database to use ms sql,access can't use index.
2.use pagination :this

Posted 12-Jul-12 22:40pm

zhxhdean