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..