如果我们在数据表中有数百万条记录，那么我们如何搜索(for循环除外) [英] If we have millions of records in a datatable how do we search except (for loop)

问题描述

如果数据表中有数百万条记录，那么什么是最好的搜索方式(不使用for循环)?

If we have millions of records in a datatable what is the best way to search (without using for loop)

推荐答案

如果要基于数据表的属性过滤数据表，则可以使用WHERE子句.

如果要在属性内搜索，请使用全文本搜索.大致上与Google相同.输入一个单词，您将获得包含该单词的结果列表.

That depends;

If you want to filter the datatable based on its attributes, you''d use a WHERE-clause.

If you are searching within an attribute, use full-text search. That would roughly work the same as Google; enter a word and you''ll get a list with results that contain that word.

这篇关于如果我们在数据表中有数百万条记录，那么我们如何搜索(for循环除外)的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！