访问DB太大，想法？ [英] Access DB too large, ideas?

问题描述

我有一个超过gb的Access数据库。我有2个表，我将每月信息转储进去。当我打开表时，只需打开表就需要5分钟。


有什么建议吗？没有一台SQL Server或一台钱。

解决方案

anoble1，


你在商店里存放什么桌子（我知道，数据 - 但是什么类型）？您的数据库是否完全正常化（这可以显着减少浪费的资源。此外，您最近是否已压缩并修复了数据库？请确保在压缩和修复之前先备份。

你可能需要在这里帮我一点。我确实每隔几天压缩和修复一次。你的意思是我猜的数据类型是什么？

仅供参考你可以免费获得SQL Server Express

I have a Access database that is over a gb. I have 2 tables that I dump monthly info in. When I open the table it takes over 5 minutes for it just to open the table.

Any suggestions? Don''t have a SQL Server or money for one.

解决方案

anoble1,

What do you store in your tables (I know, data--but what kinds)? Is your DB fully normalized (this can help significantly on wasted resources. Also, have you compacted and repaired your DB recently? Be sure to make a back up first before you compact and repair.

You may have to help me out a bit here. I compact and repair every few days for sure. Do you mean what data types I guess?

FYI you can get SQL Server Express for free.

这篇关于访问DB太大，想法？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！