Click here to Skip to main content
14,383,961 members
Rate this:
Please Sign up or sign in to vote.
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
Rate this:
Please Sign up or sign in to vote.

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!
   
Rate this:
Please Sign up or sign in to vote.

Solution 2

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.
   
Rate this:
Please Sign up or sign in to vote.

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.
   
Rate this:
Please Sign up or sign in to vote.

Solution 4

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

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




CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100