ms-access加载数据问题 [英] ms-access loading data question

问题描述

我的表格很复杂.如下所示:

i have a pretty complicated form. as you can see below:

替代文本http://img9.imageshack.us/img9/2465/test2xk .jpg

但是，数据库中我总共只有8mb的数据.

however, i have only maybe 8mb of data total in the database.

它的工作方式是将所有记录名称填充到左侧的列表框中.滚动记录时，它会为每个记录加载适当的数据

the way it works is it populates the listbox all the way on the left with all the record names. when you scroll through the records it loads the appropriate data for each record

当我一直滚动到左侧的列表框时，由于某种原因，将每条记录加载到所有适当的字段大约需要2秒钟.没有照片加载或任何巨大的东西.数据库位于本地.每条记录最多只能加载100kb

when i scroll through the listbox all the way on the left, for some reason it takes about 2 seconds to load each record into all the appropriate fields. there are no pictures loading or anything huge. the database resides locally. it's just loading maybe at most 100kb total for each record

您能告诉我是否需要这么长时间才能加载?

can you tell me whether it's supposed to take this long to load?

查询是否有问题?

这是我每次滚动列表框中的项目时正在运行的内容

this is what is running each time i scroll through the items in the listbox

SELECT u.id,u.title,u.title,u.first,u.last FROM 
  (((tblusers u LEFT JOIN tbluserstudentteacher 
     ON u.id = tbluserstudentteacher.student_teacher_user_id) 
     LEFT JOIN tblUsersSubjects ON u.id = tblUsersSubjects.user_id) 
     LEFT JOIN tblUserAvailability ON u.id=tblUserAvailability.user_id) 
     LEFT JOIN chavrusas ON u.id=chavrusas.luser_id 
       WHERE 1=1 AND (u.gender) LIKE 'm*' 
       AND (chavrusas.luser_type)='shliach' 
       AND (chavrusas.ruser_type)='shliach' AND (u.last LIKE 'd*') 
 GROUP BY u.id, u.title, u.title, u.first, u.last 
 ORDER BY last;

推荐答案

我注意到您有许多子表单，如果不使用所有子表单，除非需要它们，否则它们可能会获得更好的性能:

I notice that you have a number of subforms, you may get better performance if you do not load all the subforms until they are needed: Does it degrade performance to use subforms in MS Access?

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