加载形式问题 [英] Problem in loading form

问题描述

在我的访问数据库中，我有65000条记录
我正在将数据库中的名称以vb.net形式添加到组合框.但是加载数据需要更多时间.
如何提高查询速度..

In my access database I have 65000 records
I am adding names from the database to combobox in the vb.net form. But it takes more time to load the data.
How to increase the speed of query..

推荐答案

简单:不要加载包含65,000条记录的组合框.

不，我是说真的:将自己放在用户位置片刻.您的表单加载完毕后，他需要从65,000个项目的简短列表中选择一个选项(组合框就是这样做的).找到您想要的人要花多长时间?您是否会再次使用该软件?因为我当然不会.

寻找其他解决方案-先进行搜索，过滤，然后再进行一些用户友好的操作.而且您应该发现软件也变得越来越快...

Simple: Don''t load a combo box with 65,000 records.

No, I mean it: Put yourself in the users place for a moment. Your form loads, he needs to select a single option (which is what combo boxes do) from a short list...of 65,000 items. How long is it going to take you to find the one you want? Are you ever going to use that software again? Because I certainly wouldn''t.

Find a different solution - give then searches, filters, something just a little bit more user-friendly. And you should find your software gets faster, too...

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