怎么提高查询速度？？

Question

使用过滤的办法，即table1.filter:='字段='+''''+数据+''''；

Answer 1

加索引，也可以用 Locate 方法。

Answer 2

用LOCATE方法真的是很快，跳过了好过没有用的记录，不用遍历整张表
倪倪倪倪倪倪倪倪倪倪倪倪倪倪倪倪倪倪倪倪倪倪倪倪倪倪倪倪倪倪
倪倪倪磊磊磊磊磊磊磊磊磊磊磊磊磊磊磊磊磊磊磊磊磊磊磊磊倪倪倪
倪倪倪磊磊磊磊磊磊磊磊磊磊磊磊磊磊磊磊磊磊磊磊磊磊磊磊倪倪倪
倪倪倪倪倪倪倪倪磊磊磊倪倪倪倪倪倪倪倪磊磊磊倪倪倪倪倪倪倪倪
倪倪倪倪倪倪倪倪磊磊磊倪倪倪倪倪倪倪倪磊磊磊倪倪倪倪倪倪倪倪
倪磊磊磊磊磊磊磊磊磊磊磊磊磊磊磊磊磊磊磊磊磊磊磊磊磊磊磊磊倪
倪磊磊磊磊磊磊磊磊磊磊磊磊磊磊磊磊磊磊磊磊磊磊磊磊磊磊磊磊倪
倪磊磊磊磊倪倪倪倪磊磊磊倪倪倪倪倪倪倪倪磊磊磊倪倪倪磊磊磊倪
倪磊磊磊倪倪倪倪磊磊磊倪倪倪倪倪倪倪倪磊磊磊倪倪倪倪磊磊磊倪
倪磊磊磊倪倪倪磊磊磊倪倪倪倪倪倪倪倪倪倪磊磊磊倪倪倪磊磊磊倪
倪磊磊磊倪倪磊磊磊倪倪倪倪倪倪倪倪倪倪倪倪磊磊磊倪倪磊磊磊倪
倪磊磊磊倪磊磊磊倪倪倪倪倪倪倪倪倪倪倪倪倪倪磊磊磊倪磊磊磊倪
倪磊磊磊倪倪倪倪倪倪倪倪倪倪倪倪倪倪倪倪倪倪倪倪倪倪磊磊磊倪
倪磊磊磊磊磊磊磊磊磊磊磊磊磊磊磊磊磊磊磊磊磊磊磊磊磊磊磊磊倪
倪磊磊磊磊磊磊磊磊磊磊磊磊磊磊磊磊磊磊磊磊磊磊磊磊磊磊磊磊倪
倪倪倪倪倪倪倪倪倪倪倪倪倪倪倪倪倪倪倪倪倪倪倪倪倪倪倪倪倪倪
倪倪倪倪倪倪倪倪倪倪倪倪倪倪倪倪倪倪倪倪倪倪倪倪倪倪倪倪倪倪
倪倪倪倪倪倪倪倪倪倪倪倪倪倪倪倪倪倪倪倪倪倪倪倪倪倪倪倪倪倪
倪倪倪磊磊磊磊磊磊磊磊磊磊磊磊磊磊磊磊磊磊磊磊磊磊磊磊倪倪倪
倪倪倪磊磊磊磊磊磊磊磊磊磊磊磊磊磊磊磊磊磊磊磊磊磊磊磊倪倪倪
倪倪倪磊磊磊倪倪倪倪倪倪倪倪磊磊磊倪倪倪倪倪倪倪磊磊磊倪倪倪
倪倪倪磊磊磊倪倪倪磊磊磊磊磊磊磊磊磊磊磊磊倪倪倪磊磊磊倪倪倪
倪倪倪磊磊磊倪倪倪倪倪倪倪倪磊磊磊倪倪倪倪倪倪倪磊磊磊倪倪倪
倪倪倪磊磊磊倪磊磊磊磊磊磊磊磊磊磊磊磊磊磊磊磊倪磊磊磊倪倪倪
倪倪倪磊磊磊倪倪倪倪倪倪倪倪倪倪倪倪倪倪倪倪倪倪磊磊磊倪倪倪
倪倪倪磊磊磊倪倪倪倪倪磊磊磊磊磊磊磊磊倪倪倪倪倪磊磊磊倪倪倪
倪倪倪磊磊磊倪倪倪倪倪磊磊倪倪倪倪磊磊倪倪倪倪倪磊磊磊倪倪倪
倪倪倪磊磊磊倪倪倪倪倪磊磊倪倪倪倪磊磊倪倪倪倪倪磊磊磊倪倪倪
倪倪倪磊磊磊倪倪倪倪倪磊磊倪倪倪倪磊磊倪倪磊倪倪磊磊磊倪倪倪
倪倪磊磊磊倪倪倪倪倪倪磊磊磊磊磊磊磊磊倪倪磊磊倪磊磊磊倪倪倪
倪磊磊磊倪倪倪倪倪倪倪倪倪倪倪倪倪倪倪倪倪倪磊磊磊磊磊倪倪倪
磊磊磊倪倪倪倪倪倪倪倪倪倪倪倪倪倪倪倪倪倪倪倪磊磊磊磊倪倪倪
倪倪倪倪倪倪倪倪倪倪倪倪倪倪倪倪倪倪倪倪倪倪倪倪倪倪倪倪倪倪
倪倪倪倪倪倪倪倪倪倪倪倪倪倪倪倪倪倪倪倪倪倪倪倪倪倪倪倪倪倪
倪倪倪倪倪倪倪倪倪倪倪倪倪倪倪倪倪倪倪倪倪倪倪倪倪倪倪倪倪倪
倪倪倪倪倪倪倪倪倪倪倪倪倪倪磊磊磊倪倪倪倪倪倪倪倪倪倪倪倪倪
倪倪倪倪倪磊磊磊磊倪倪倪倪倪磊磊磊倪倪倪倪倪倪倪倪倪倪倪倪倪
倪倪倪倪倪磊磊磊倪倪倪倪倪倪磊磊磊倪倪倪倪倪倪倪倪倪倪倪倪倪
倪倪倪倪倪磊磊倪倪倪倪倪倪倪磊磊磊倪倪倪倪倪倪倪倪倪倪倪倪倪
倪倪倪倪磊磊磊磊磊磊磊磊磊磊磊磊磊磊磊磊磊磊磊磊磊磊倪倪倪倪
倪倪倪磊磊磊磊磊磊磊磊磊磊磊磊磊磊磊磊磊磊磊磊磊磊磊倪倪倪倪
倪倪磊磊倪倪倪倪倪倪倪倪倪倪磊磊磊倪倪倪倪倪倪倪倪倪倪倪倪倪
倪磊磊倪倪倪倪倪倪倪倪倪倪倪磊磊磊倪倪倪倪倪倪倪倪倪倪倪倪倪
磊倪倪倪倪倪磊磊磊磊磊磊磊磊磊磊磊磊磊磊磊磊磊磊倪倪倪倪倪倪
倪倪倪倪倪倪磊磊磊磊磊磊磊磊磊磊磊磊磊磊磊磊磊磊倪倪倪倪倪倪
倪倪倪倪倪倪倪倪倪倪倪倪倪倪磊磊磊倪倪倪倪倪倪倪倪倪倪倪倪倪
倪倪倪倪倪倪倪倪倪倪倪倪倪倪磊磊磊倪倪倪倪倪倪倪倪倪倪倪倪倪
倪磊磊磊磊磊磊磊磊磊磊磊磊磊磊磊磊磊磊磊磊磊磊磊磊磊磊磊磊倪
倪磊磊磊磊磊磊磊磊磊磊磊磊磊磊磊磊磊磊磊磊磊磊磊磊磊磊磊磊倪
倪倪倪倪倪倪倪