Oracle中的性能问题 [英] Performance issue in Oracle

问题描述

您好，

我有一个搜索字符串，我需要显示与来自特定Oracle DataTable的搜索字符串相似的词.

我能够做到，但是由于搜索是通过整个
进行的 DataTable非常耗时，因此会导致性能问题.

请提出建议.

Hi Folks,

I have a search string and I need to display the words similar to that search string from a particular Oracle DataTable.

I am able to do that but since the search is through the entire
DataTable it''s time consuming, thus creating a performance issue.

Please suggest how do I go for it.

推荐答案

您似乎将整个表加载到数据表中，然后在C#代码中搜索数据表.这是最恐怖的事情.而是在SQL代码中搜索数据，并仅带那些与搜索条件匹配的行.

You seem to load the entire table into the data table and then search the data table in your C# code. This is the most horrible thing to do. Instead search data in your SQL code and bring only those rows that match the search criteria.

SELECT Col1, Col2, .... 
FROM MyTable 
WHERE Col1 LIKE '%<<searchText>>%'
OR Col2 LIKE '%<<searchText>>%'
OR ............

在要搜索的列上创建索引.可能有帮助.

Create Indexes on the columns that you are searching. It might help.

看看 Oracle文字 [ ^ ]

最好的问候
Espen Harlinn

Take a look at Oracle Text[^]

Best regards
Espen Harlinn

这篇关于Oracle中的性能问题的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！