Is Microsoft Access slow?

最新推荐文章于 2022-08-11 09:53:56 发布

原创最新推荐文章于 2022-08-11 09:53:56 发布 · 3k 阅读

0 ·

CC 4.0 BY-SA版权

文章标签：

#microsoft #access #sql server #performance #compression #query

Data Access 专栏收录该内容

10 篇文章

订阅专栏

本文讨论了MSAccess在高负载情况下的局限性，并建议切换到MSDE2000或SQLServer2005Express。对于少量用户仍存在的性能问题，文章提供了数据库设计方面的优化建议，包括表规范化、Unicode压缩设置及合理使用索引等。

MS Access is not designed for high load such as web server. The most usual bottleneck is file writing Switch to Microsoft SQL Server Desktop Engine 2000 (MSDE 2000) or Microsoft SQL Server 2005 Express in this case.

If u have only a few users and the performance is still poor, check your database design. Generally poor performance is due to poor design. Normalize the table but don't over normalize it - there can be too much of a good thing in sometimes. All text fields longer than a few characters should have Unicode Compression set to Yes. Whenever possible, use lookup lists for text fields. Design the lookup lists with an auto number field to link a lookup table with the main table. Always index fields that you put in the criteria section of the query design screen. Or, in other words, index all fields on the right side of a where clause. If all else fails: split the query into two or more queries. Restrict as many records as possible in the first query and use the query as input to the next query.