blocks|key|1673996|text|像SQL+Server+Express、MySQL和PostgreSQL这样的东西是免费的，不需要购买许可证。|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|1673997|为了提高搜索速度，您可能还需要查看为表定义了哪些索引，搜索到底在做什么等等。|1673998|entityMap|0|LINK|mutability|MUTABLE|url|http://www.microsoft.com/express/database/|1|http://www.mysql.com/downloads/mysql/|2|http://www.postgresql.org/^0|1|I|0|K|5|1|Q|A|2|0|0^^$0|@$1|2|3|4|5|6|7|R|8|@]|9|@$A|S|B|T|1|U]|$A|V|B|W|1|X]|$A|Y|B|Z|1|10]]|C|$]]|$1|D|3|E|5|6|7|11|8|@]|9|@]|C|$]]|$1|F|3|-4|5|6|7|12|8|@]|9|@]|C|$]]]|G|$H|$5|I|J|K|C|$L|M]]|N|$5|I|J|K|C|$L|O]]|P|$5|I|J|K|C|$L|Q]]]]

Things like <a href="http://www.microsoft.com/express/database/" rel="noreferrer">SQL Server Express</a>, <a href="http://www.mysql.com/downloads/mysql/" rel="noreferrer">MySQL</a> and <a href="http://www.postgresql.org/" rel="noreferrer">PostgreSQL</a> are available for free, no license purchase necessary.

For improving search speeds, you will probably also want to look at things like what indexes are defined for the table, what exactly searches are doing, et cetera.

blocks|key|1674199|text|第二，火鸟的建议。我们使用它已经5年了，从来没有问题。跨平台嵌入式服务器部署..。非常出色。哦，还有啤酒一样的免费。Mozilla公共LIcense。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1674200|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|D|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|E|8|@]|9|@]|A|$]]]|C|$]]

2nd the recommendation for Firebird. We've been using it for about 5 years and never had an issue. Cross platform, embedded &amp; server deployments... brilliant. Oh, and Free as in Beer. Mozilla Public LIcense.

blocks|key|1674210|text|把我作为火鸟的另一个推荐人。我们使用它与我们的商业点的销售产品。我们在1000多个站点上安装了它，数据库大小可达40%2B千兆字节。它快速、稳定、简单、易于部署，不需要管理。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1674211|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|D|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|E|8|@]|9|@]|A|$]]]|C|$]]

Put me down as another recommendation for Firebird. We use it with our commercial Point of Sale product. We have it installed at over 1,000 sites, with databases as large as 40+ Gigabytes. It's fast, stable, simple, easy to deploy, and requires no management.

blocks|key|1366648|text|您可以将Access数据库替换为SQL+Server数据库，该数据库将很好地向前扩展。您可以使用SQL+Server+Express，它是免费的，并且支持高达4Gb的数据库。|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|1366649|entityMap|0|LINK|mutability|MUTABLE|url|http://www.microsoft.com/sqlserver/2008/en/us/express.aspx^0|1C|I|0|0^^$0|@$1|2|3|4|5|6|7|L|8|@]|9|@$A|M|B|N|1|O]]|C|$]]|$1|D|3|-4|5|6|7|P|8|@]|9|@]|C|$]]]|E|$F|$5|G|H|I|C|$J|K]]]]

Your could replace the Access Database with a SQL Server database that will scale well moving forward. You can use <a href="http://www.microsoft.com/sqlserver/2008/en/us/express.aspx" rel="nofollow noreferrer">SQL Server Express</a> which is free and supports databases up to 4Gb I beleive.

blocks|key|1673967|text|SQL+Server+Express。免费的数据库大小可达10+GB。|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|1673968|entityMap|0|LINK|mutability|MUTABLE|url|http://www.microsoft.com/express/Database/^0|0|I|0|0^^$0|@$1|2|3|4|5|6|7|L|8|@]|9|@$A|M|B|N|1|O]]|C|$]]|$1|D|3|-4|5|6|7|P|8|@]|9|@]|C|$]]]|E|$F|$5|G|H|I|C|$J|K]]]]

<a href="http://www.microsoft.com/express/Database/" rel="nofollow noreferrer" title="SQL Server Express">SQL Server Express</a>. Free for database size up to 10 GB.

blocks|key|1674008|text|我热烈推荐MySQL。有时是免费的很容易安装在Windows和linux上。|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|1674009|也有许多很好的免费工具来管理它的内容，如表，用户，索引等。|1674010|entityMap|0|LINK|mutability|MUTABLE|url|http://www.mysql.com/about/legal/licensing/oem/^0|B|6|0|0|0^^$0|@$1|2|3|4|5|6|7|N|8|@]|9|@$A|O|B|P|1|Q]]|C|$]]|$1|D|3|E|5|6|7|R|8|@]|9|@]|C|$]]|$1|F|3|-4|5|6|7|S|8|@]|9|@]|C|$]]]|G|$H|$5|I|J|K|C|$L|M]]]]

I warmly recommend MySQL. <a href="http://www.mysql.com/about/legal/licensing/oem/" rel="nofollow noreferrer">Its sometimes free</a> and is easy to install on both Windows and linux.

There are also a lots of great free tools to manage its content like tables, users, indexes etc...

blocks|key|1674091|text|非常适合这一点。http://www.microsoft.com/express/database/|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|1674092|entityMap|0|LINK|mutability|MUTABLE|url|http://www.microsoft.com/express/database/^0|8|16|0|0^^$0|@$1|2|3|4|5|6|7|L|8|@]|9|@$A|M|B|N|1|O]]|C|$]]|$1|D|3|-4|5|6|7|P|8|@]|9|@]|C|$]]]|E|$F|$5|G|H|I|C|$J|K]]]]

SQL Server Express is a perfect fit for this. <a href="http://www.microsoft.com/express/database/" rel="nofollow noreferrer">http://www.microsoft.com/express/database/</a>

blocks|key|1366714|text|你可以看看火鸟|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|1366715|Firebird是桌面应用程序最好的数据库之一，并且将一直免费。|1366716|从访问firebird到转换数据库，有些工具是存在的。|1366717|entityMap|0|LINK|mutability|MUTABLE|url|http://www.firebirdnews.org/docs/fb2min.html|1|http://www.clevercomponents.com/products/datapump/ibdatapump.asp^0|5|2|0|0|0|C|5|1|0^^$0|@$1|2|3|4|5|6|7|R|8|@]|9|@$A|S|B|T|1|U]]|C|$]]|$1|D|3|E|5|6|7|V|8|@]|9|@]|C|$]]|$1|F|3|G|5|6|7|W|8|@]|9|@$A|X|B|Y|1|Z]]|C|$]]|$1|H|3|-4|5|6|7|10|8|@]|9|@]|C|$]]]|I|$J|$5|K|L|M|C|$N|O]]|P|$5|K|L|M|C|$N|Q]]]]

You can take a look at <a href="http://www.firebirdnews.org/docs/fb2min.html" rel="nofollow noreferrer">Firebird</a>

Firebird is one of the best database for desktop application and will allways be free.

Some tools exist to <a href="http://www.clevercomponents.com/products/datapump/ibdatapump.asp" rel="nofollow noreferrer">convert database</a> from access to firebird.

blocks|key|1674152|text|我将研究是否需要将大表分解为较小的表(很少需要，但仍然需要)，以及它上有哪些索引。对于数据库软件，我会推荐PostgreSQL。它是免费的，易于使用(我认为设置很容易，尽管其他人不同意)，而且对于企业应用程序来说，它足够快了。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1674153|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|D|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|E|8|@]|9|@]|A|$]]]|C|$]]

I would look into if the big table needs to be broken up into smaller ones(rarely needed, but still) and also what indexes are on it. And for Database software I would recommend PostgreSQL. It is free, easy to use(and I consider it easy to setup, though others beg to differ), and it is fast enough for enterprise applications.

blocks|key|1674174|text|我还推荐火鸟。|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|1674175|它对于您的场景的主要优点是(从我的头脑中)：|1674176|嵌入式版本。您可以随应用程序一起发布它--不需要单独的安装工具包，也不需要.NET依赖项等。|unordered-list-item|1674177|稍后，您可以无缝地扩展到完整的客户机-服务器模型。不需要更改代码。|1674178|很小的足迹|1674179|整个数据库存储在一个文件中。与其他解决方案相比，部署起来容易得多。|1674180|您可以在您想要的任何平台上使用您的服务器:+Windows、Linux、MacOSX等。当然，您也可以在相同的平台上使用您的客户端，但是既然您提到了访问，我想您应该有一个Windows应用程序。|1674181|不需要服务器管理。只是起作用了。|1674182|entityMap|0|LINK|mutability|MUTABLE|url|http://www.firebirdsql.org/^0|4|2|0|0|0|0|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|10|8|@]|9|@$A|11|B|12|1|13]]|C|$]]|$1|D|3|E|5|6|7|14|8|@]|9|@]|C|$]]|$1|F|3|G|5|H|7|15|8|@]|9|@]|C|$]]|$1|I|3|J|5|H|7|16|8|@]|9|@]|C|$]]|$1|K|3|L|5|H|7|17|8|@]|9|@]|C|$]]|$1|M|3|N|5|H|7|18|8|@]|9|@]|C|$]]|$1|O|3|P|5|H|7|19|8|@]|9|@]|C|$]]|$1|Q|3|R|5|H|7|1A|8|@]|9|@]|C|$]]|$1|S|3|-4|5|6|7|1B|8|@]|9|@]|C|$]]]|T|$U|$5|V|W|X|C|$Y|Z]]]]

I also recommend <a href="http://www.firebirdsql.org/" rel="nofollow noreferrer">Firebird</a>.

Its key advantages for your scenario are (from top of my head):

<ul>
<li>embedded version. You can ship it with your application - no separate installation kit needed, no .NET dependencies etc.</li>
<li>later on you can scale seamlessly to the full client-server model. No code changes required.</li>
<li>very small footprint</li>
<li>the entire database is stored in a single file. Much easier to deploy compared with other solutions.</li>
<li>you can have your server on any platform you want: Windows, Linux, MacOSX etc. Of course, you can have your client also on the same platforms but since you mentioned Access, I suppose that you have a Windows application.</li>
<li>no need for server administration. It just works.</li>
</ul>

blocks|key|124377|text|我也推荐PostgreSQL+(特别是作为MySQL的替代方案)。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|124378|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|D|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|E|8|@]|9|@]|A|$]]]|C|$]]

I recommend PostgreSQL as well (especially as an alternative to MySQL)

blocks|key|124420|text|似乎没有人提到这一点，但甲骨文也做了一个免费啤酒版本的他们的数据库：甲骨文快报版+(又名XE)。它仅限于1+CPU、1GB+RAM和4GB用户数据，但对于您的应用程序来说，这听起来足够大。|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|124421|至于数据库设计，只有一个表听起来更像是电子表格，而不是数据库应用程序。可能你有很多去基因处理的数据。将这些表拆分成较小的非重复表很可能会加快某些查询的速度。但是，如果您只有20列，则可能没有太多的调优空间。|124422|至于推荐，问题是，你知道哪些产品？如果您熟悉Access，那么我建议您尝试优化现有数据库。我使用了Access数据库，这些数据库存储了数百万行，并且它们的性能足够好。毕竟，不能保证将相同的设计转移到不同的产品上，会自动使事情运行速度提高x倍。Access作为工具的另一个优点是它附带了内置的前端工具。如果从Access迁移，您可能需要考虑重新构建应用程序。|124423|entityMap|0|LINK|mutability|MUTABLE|url|http://www.oracle.com/technology/products/database/xe/index.html^0|Y|6|0|0|0|0^^$0|@$1|2|3|4|5|6|7|P|8|@]|9|@$A|Q|B|R|1|S]]|C|$]]|$1|D|3|E|5|6|7|T|8|@]|9|@]|C|$]]|$1|F|3|G|5|6|7|U|8|@]|9|@]|C|$]]|$1|H|3|-4|5|6|7|V|8|@]|9|@]|C|$]]]|I|$J|$5|K|L|M|C|$N|O]]]]

No-one ever seems to mention it, but Oracle also do a free-as-in-free-beer version of their database: <a href="http://www.oracle.com/technology/products/database/xe/index.html" rel="nofollow noreferrer">Oracle Express Edition</a> (aka XE). It is limited to 1 CPU, 1GB RAM and 4GB of user data but that sounds plenty big enough for your application.

As for your database design, just one table sounds more like a spreadsheet than a database application. Probably you have lots of denormalised data. Splitting those out into smaller de-duplicated tables might well speed up certain queries. However if you only have twenty columns there may not be a lot of scope for tuning.

As for recommendation, the question is, which products do you know? If you have a familiarity with Access then I suggest you try to optimize your existing database. I have worked with Access databases which store several million rows and they performed well enough. After all, there is no guarantee that moving the same design to a different product will automatically make things run x times faster. Another advantage of Access as a tool is that it comes with a built-in front-end tool. If you move from Access you may need to think about re-building your application.

blocks|key|1674281|text|哇，大家有很多平台推荐给你。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1674282|我就这么说吧。|1674283|如果您觉得有设计问题和平台问题，为什么不先尝试一下设计更改呢？无论如何，这些都是你可能会做的改变。|1674284|如果它们在访问方面没有任何性能差异，那么您的情况也不会更糟，因为这些更改提高了任何平台上的可维护性。|1674285|然后，您可以尝试其他平台的知识，你有一个坚实的设计，你没有浪费任何时间。|1674286|entityMap^0|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|L|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|M|8|@]|9|@]|A|$]]|$1|D|3|E|5|6|7|N|8|@]|9|@]|A|$]]|$1|F|3|G|5|6|7|O|8|@]|9|@]|A|$]]|$1|H|3|I|5|6|7|P|8|@]|9|@]|A|$]]|$1|J|3|-4|5|6|7|Q|8|@]|9|@]|A|$]]]|K|$]]

Wow, folks have a lot of platform recommendations for you.

Let me just say this.

If you feel like there are design issues as well as platform issues, why not try the design changes first? These are changes you are likely to make anyway.

If they make no performance difference in Access, you are no worse off, since these changes improve maintainability on any platform.

Then you can try other platforms with the knowledge that you have a solid design, and that you have not wasted any time.

blocks|key|124472|text|SQLite也可以成为候选人。|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|124473|entityMap|0|LINK|mutability|MUTABLE|url|http://www.sqlite.org/features.html^0|0|6|0|0^^$0|@$1|2|3|4|5|6|7|L|8|@]|9|@$A|M|B|N|1|O]]|C|$]]|$1|D|3|-4|5|6|7|P|8|@]|9|@]|C|$]]]|E|$F|$5|G|H|I|C|$J|K]]]]

<a href="http://www.sqlite.org/features.html" rel="nofollow noreferrer">SQLite</a> can also be a candidate.

blocks|key|1674319|text|我会再次承诺，不使用任何快递-是的，你的小，但如果业务起飞，并需要更高的负荷在未来-当然，你希望它的方式?？不想要切换db层/运行2+.|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1674320|我会看到MySQL或火鸟(习惯于)都是非常高的质量。|1674321|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|F|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|G|8|@]|9|@]|A|$]]|$1|D|3|-4|5|6|7|H|8|@]|9|@]|A|$]]]|E|$]]

I would recommand not going with express anything - yep your small but what if the busness takes off and need much higher loads in the future - surely thats the way you want it to go ?? do not want to have to switch db layers / run 2 ..

I would look at MySQL or Firebird (used to borland interbase) both very high quality.

I have to develop a new (desktop) app for a small business. This business currently has an Access database with millions of records. The file size is about 1.5 GB. The boss told me that searching on this DB is very slow. The DB consists of a single table with about 20 fields.

I also think the overall DB design isn't great. I thought to use another DB server with a new design to improve both performance and efficiency.

Considering this is a relatively small business, I don't want to spend much for a DB license, so I want to ask you what would you do.

<ul>
<li>Continue to use Access, maybe improving and optimizing the DB in some way</li>
<li>Buy a DB server license (in this case, which one?)</li>
<li>? (any idea?)</li>
</ul>

Which DB Server should I use?

翻译质量差，导致语言生硬或混乱。

没有提供实际的解决方法或示例。

解答不清晰，无法理解或解决问题。

页面排版不美观，阅读体验差。

文章

问答

视频

教程

学习中心

腾讯云实验室

直播

竞赛

腾讯云代码分析专区

腾讯iOA零信任安全管理系统专区

腾讯云架构师技术同盟交流圈

腾讯云数据库专区

腾讯云智能顾问专区

腾讯云原生专区

腾讯混元专区

腾讯云TCE专区

腾讯云Lighthouse专区

腾讯云HAI专区

腾讯云Edgeone专区

腾讯云存储专区

腾讯云智能专区

腾讯轻联专区 

腾讯云开发专区

TAPD专区

腾讯轻量云游戏服专区

腾讯云最具价值专家

腾讯云架构师技术同盟

腾讯云创作之星

腾讯云开发者先锋

腾讯云AI代码助手

云原生构建

TAPD 敏捷项目管理

Cloud Studio

SDK中心

API中心

命令行工具

功能1上新10个字符

功能2描述100个字符功能2描述100个字符功能2描述100个字符功能2描述100个字符功能2描述100个字符功能2描述100个字符功能2描述100个字符功能2描述100个字符功能2描述100个字符。

功能2上新100个字符功能2上新100个字符功能2上新100个字符功能2上新100个字符功能2上新100个字符功能2上新100个字符功能2上新100个字符功能2上新100个字符功能2上新100个字符。

功能5描述100个字符功能5描述100个字符功能5描述100个字符功能5描述100个字符功能5描述100个字符功能5描述100个字符

功能5上新100个字符功能5上新100个字符功能5上新100个字符功能5上新100个字符功能5上新100个字符功能5上新100个字符功能5上新100个字符功能5上新100个字符功能5上新100个字符功能5上新100个字符

功能4上新

文章&问答评论现已支持表情

全新交互，全新视觉，新增快捷键、悬浮工具栏、高亮块等功能并同时优化现有功能，全面提升创作效率和体验

社区富文本编辑器全新改版！诚邀体验～ 

精选全网热门MCP server，让你的AI更好用 🚀

💥开发者 MCP广场重磅上线！

涵盖代码开发、场景应用、自动测试全流程，助你从零构建专属AI助手

一站式MCP教程库，解锁AI应用新玩法

聚焦“写作效率、视觉美观与运行性能”三方面进行全面升级，为您提供更高效、稳定的创作环境

社区富文本&Markdown编辑器全新改版上线，欢迎大家体验!

诚挚邀请您参与本次调研，分享您的真实使用感受与建议。您的反馈至关重要，感谢您的支持与参与！

社区新版编辑器体验调研

我必须为一个小企业开发一个新的(桌面)应用程序。该企业目前拥有一个拥有数百万条记录的Access数据库。文件大小约为1.5GB。老板告诉我在这个数据库上搜索很慢。DB由一个包含大约20个字段的表组成。我还认为整个DB设计不是很好。我想使用另一个带有新设计的DB服务器来提高性能和效率。考虑到这是一个相对较小的业务，我不想花很多钱购买DB许可证，所以我想问你你会怎么做。继续使用Access，可能会以某

问我应该使用哪个数据库服务器？
EN

回答 15

Stack Overflow用户

Stack Overflow用户

Stack Overflow用户

社区

活动

圈层

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问我应该使用哪个数据库服务器？EN

回答 15

Stack Overflow用户

Stack Overflow用户

Stack Overflow用户

社区

活动

圈层

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问我应该使用哪个数据库服务器？
EN