局域网中的MSACCESS数据库速度慢 [英] MSACCESS DATABASE SPEED SLOW IN LAN

问题描述

当通过局域网访问数据非常慢时





从表中选择MAX（VNO）





从25000记录中获得最大值25秒。





ANY SOLUTION？



数据库：MSACESS





谢谢

解决方案

可能 Google [ ^ ]有帮助。

最初想到的两个可能的原因：

- 连接速度慢。由于Access基本上只是一个共享文件，因此与服务器的连接需要足够快

- 没有合适的索引。要确保性能，您应该创建满足最常见查询的索引。有关详细信息，请参阅： CREATE INDEX语句（Microsoft Access SQL） [ ^ ]

如果您在共享网络上使用MS Access数据库。请在下面试试

  1 。要通过网络获得最佳性能，您应该定期压缩和修复Microsoft Access文件。 
 
  2 。如果要压缩位于服务器或共享文件夹上的共享Microsoft Access数据库，请确保没有其他人将其打开。

WHILE ACCESSING DATA THROUGH LAN IS VERY SLOW


SELECT MAX(VNO) FROM TABLE


IT IS 25 SECOND TO GET MAX VALUE FROM 25000 RECORD.


ANY SOLUTION?

DATABASE : MSACESS


THANKS

解决方案

Probably Google[^] helps.

Two possible reasons that initially come to mind:
- slow connection. Since Access is basically just a "shared file", the connection to the server needs to be fast enough
- no proper indexes. To ensure performance, you should create indexes that satisfy the most common queries. More information, see: CREATE INDEX Statement (Microsoft Access SQL)[^]

If you are using MS Access database on shared network. Please try below

1. To Get optimal performance over the network, you should compact and repair your Microsoft Access files on a regular basis.

2. If you are compacting a shared Microsoft Access database that is located on a server or shared folder, make sure that no one else has it open.

这篇关于局域网中的MSACCESS数据库速度慢的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！