PHP dBase 作为 SQLite 的替代品
我在这里读到了一些评论，说 dBase 是一个死系统，没有人再使用它。我在 php 中比较了 dBase 和 SQLite，在我的测试中，dBase 比 SQLite 和类似系统有许多优点：
- 它的数据库文件要小得多
- 使用更少的内存写入文件速度非常快
- 文件大小的增长影响可以忽略不计关于查询。
我承认 SQLite 有更广泛的命令，具有更好的灵活性；但是 dBase 不可靠或无法将其发送到后台的原因可能是什么？
我不知道并发连接（尽管 SQLite 也有严重的限制）。请评论这个问题。
摘要：除了功能之外，我只是想知道 dBase 在性能方面可能存在哪些缺点。
I have read several comments here that dBase is a dead system and no one use it anymore. I compared dBase and SQLite in php, and in my test dBase has many advantages over SQLite and similar systems:
- Its database file is much smaller
- Writing to the file is very faster with using a lesser amount of memory
- Growing the file size has a negligible effect on the query.
I admit that SQLite has a wider range of commands for a better flexibility; but what can be the reason of unreliability or incapability of dBase which sent it to the background?
I have no idea about concurrent connections (though SQLite has serious limitations too). Please comment on this issue.
Summary: Apart from functionality, I just wanted to know what is possible disadvantage of dBase in performance.
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（2）
如果您正在使用单个表，那么您可能不会发现太大的差异（除了 dBase 中缺乏 SQL 命令支持之外），但是一旦您开始使用关系数据并拥有多个相关表，dBase 的使用就会崩溃。您必须使用 dBase 将代码中的所有关系粘合在一起，而使用 SQLite，您可以拥有完整的外键支持并具有关系依赖性。
有些人可能会提出反对意见，认为 InterBase 服务器允许您与 dBase 建立关系，但这实际上超出了您所说的范围。
总结：对于单个表，可能没有太大区别，对于多个相关表，基于 SQL 的系统（如 SQLite）有很多优势。
If you are working with a single table then you might not find much difference (aside from the lack of SQL command support in dBase), but as soon as you start using relational data and having multiple related tables, use of dBase falls apart. You have to glue all your relationships together in code with dBase where with SQLite you can have full foreign key support and have relational dependencies.
Some might raise the objection that an InterBase server allows you to have relationships with dBase, but that is really outside the scope of what you're saying.
Summary: for single tables, maybe not much difference, for multiple, related tables, lots of of advantage to SQL-based systems like SQLite.
对于沙箱数据库来说，性能不是问题。他们都一样。
“功能”也是如此。是的，您可以浪费一些时间来发现一些差异。最终您的数据量将会增长，您将转向一些成人 DBMS。
Performance is not an issue for sandbox databases. They all the same.
Same for the "features". Yes, you can waste some time to find some difference. Then eventually your data size will grow up and you will move to some adult DBMS.