关键字在SQL Query中搜索,需要很长时间.. [英] keyword Seaching in SQL Query, take Long time..
问题描述
我在Sql数据库中有一个表名为判断,
在表格中我有一个TEXT字段列名 Jug_text ,
包含大约1000条文本行,
和表格在数据库中总共有50,000行...
QUERY:从判断中选择* Jug_text喜欢'%Arun Gauttam%'
现在当我使用Like关键字(ON SERVER)应用搜索查询时,
需要2或3分钟才能回复,
AT本地需要10秒..,
那么我能做什么,解决我的问题,因为我使用Asp.net项目和如果查询需要2或3分钟发生服务器超时错误..
我还看到一个网站具有与我相同的搜索机制,以及搜索结果只有1或2秒......
http://www.taxmann.com/ [ ^ ]
那么他们用什么样的机制进行搜索.. ???
现在我的问题是:
1我如何快速取得结果,
2还有其他搜索技巧(比如我将Jug_text列数据保存到其他文本文件中)然后在该文本文件中搜索)
3.或者有任何类型的SERVER问题,(我使用虚拟服务器..)
我到目前为止尝试了什么..
1 全额税搜索 ..(免税,包含等)
2使用 RowNo 属性更改查询,并在DataTable中一次只获取20行显示在网站上..
阅读以下内容: http://stackoverflow.com/问题/ 478472 / sql-full-text-search-vs-like [ ^ ]
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..解决方案Read the following : http://stackoverflow.com/questions/478472/sql-full-text-search-vs-like[^]
这篇关于关键字在SQL Query中搜索,需要很长时间..的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!