Click here to Skip to main content
15,891,787 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
I have a table name as judgement in Sql Database,
In table i have a TEXT filed Column name Jug_text,
which contain around 1000 text line,

and Table Have Total 50,000 Rows in Database..



QUERY:select * from judgement where Jug_text Like '%Arun Gauttam%'

now when i apply Search query using Like keyword(ON SERVER),
It take 2 or 3 min to respond,

AT Local it take Only 10 sec..,

So what Can i do,to solve my Problem,because i use Asp.net project and if Query take 2 or 3 min There is Server-Time-Out Error is occurs..

And i also see one site which have same Search mechanism Like Me,and there search Result is came in just 1 or 2 Second..
http://www.taxmann.com/[^]

so what kind of Mechanism they use for Searching..???

Now My Question is:
1 How i take result fastly,
2 there is any other Trick for Searching(like I Save Jug_text column data into Other Text file and then Search in that text file)
3. Or there is any kind of SERVER problem,(i use Virtual Server..)


What i Try SO far..

1 Full Tax Search..(Free tax,contains etc)
2 Change Query using "RowNo" property and take only 20 rows at a time in DataTable for disply in website..
Posted

1 solution

 
Share this answer
 

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