表单打开需要5秒才正常吗？ [英] Is it normal that it takes 5 seconds for a form to open?

问题描述

我在Windows XPPRO下使用Access 2k。该表单基于另一个查询基于查询

。我应该怎样做才能提高性能？


谢谢，


Paul

解决方案

" Paul T. Rong" <等*** @ hotmail.com>写道：

我该怎么做才能提高性能？

看这里：

http://members.iinet.net.au /@allenbr...html#usability


问候，

基思。

< blockquote> RE /

我在Windows XPPRO下使用Access 2k。该表单基于另一个查询的查询。我该怎么做才能提高性能？

这可能是关于吸管，但是表格中是否有任何图形？


我继承了一个应用程序形式与一个cutie图片

东西或其他（严格装饰），永远加载。

删除pic并正常加载 - 即几乎立即。

-

PeteCresswell

Paul T. R ong写道：

我在Windows XPPRO下使用Access 2k。该表单基于另一个查询的查询。我该怎么做才能提高性能？

谢谢，

Paul

除了其他人提供的精彩提示......

您的查询中是否有子选择？例如

从表1中选择ID其中ID In（从表2中选择ID）

次选是很好的性能抑制因素。

I use Access 2k under Windows XPPRO.The form is based on a query which is
based on another query.What should I do to improve the performance?

Thanks,

Paul

解决方案

"Paul T. Rong" <et***@hotmail.com> wrote:

What should I do to improve the performance?

Look here:

http://members.iinet.net.au/~allenbr...html#usability

Regards,
Keith.

RE/

I use Access 2k under Windows XPPRO.The form is based on a query which is
based on another query.What should I do to improve the performance?

This is probably grasping at straws, but does the form have any graphics in it?

I inherited an app once that had a form with a cutsie picture of
something-or-other (strictly decoration) that took forever to load.
Remove the pic and it loaded normally - i.e. almost instantly.
--
PeteCresswell

Paul T. Rong wrote:

I use Access 2k under Windows XPPRO.The form is based on a query which is
based on another query.What should I do to improve the performance?

Thanks,

Paul

Besides the great tips the others provided...
Does your query have a sub-select in it? Such as
Select Id From Table1 Where ID In (Select ID From Table2)
Sub-selects are great performance inhibitors.

这篇关于表单打开需要5秒才正常吗？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！