C＃数据库 [英] Database for C#

问题描述

嗨！


在我目前的项目中，我使用MS Access作为数据库。我知道一些数据库，比如SQL Server，Oracle，mySQL和IBM的DB / 2，但不再是Stand-

。数据库。


有没有人知道数据库，我可以像MS Access一样使用（这意味着，无需安装像MySQL或SQL Server这样的数据库）并且作为MS Access有更多的性能？b $ b？我最后一次使用MS Access（大约4年前b
）我有超过10.000个数据集的性能问题！


感谢您的帮助或/和评论


问候


马蒂亚斯

Hi!

In my current Project i use MS Access as Database. I know some Databases
like SQL Server, Oracle, mySQL and the DB/2 from IBM, but no more "Stand-
alone" Databases.

Did anyone know a Database, where i can use like MS Access (this means,
without needing to install a Database like mySQL or SQL Server) and has
more performance as MS Access? The last time i used MS Access (about 4
years ago) i had some performance Problems with more than 10.000 Datasets!

Thanks for your help or/and comments

Regards

Matthias

推荐答案

马蒂亚斯，


不确定我理解你的问题;你想获得一个数据库，你可以运行而无需安装？ ：-） 开玩笑。 MySQL非常容易安装和使用......如果我是你，我会给你一个旋转。它肯定会给你提供比访问更好的性能。


~harris


" Matthias Kwiedor"写道：

Matthias,

Not sure I understand your question; you want to get a database you can run without having to install?? :-) Just kidding. MySQL is super easy to both install and use... I''d give that a spin if I were you. It would defnitely give you better perf than Access.

~harris

"Matthias Kwiedor" wrote:

嗨！

在我目前的项目中，我使用MS Access作为数据库。我知道一些数据库，比如SQL Server，Oracle，mySQL和IBM的DB / 2，但不再是Stand-
。数据库。

有没有人知道数据库，我可以像MS Access一样使用（这意味着，无需安装像MySQL或SQL Server这样的数据库）并且有更多的数据库
性能如MS Access？我最后一次使用MS Access（大约4年前）我有超过10,000个数据集的性能问题！

感谢您的帮助或/和评论

Matthias

Hi!

In my current Project i use MS Access as Database. I know some Databases
like SQL Server, Oracle, mySQL and the DB/2 from IBM, but no more "Stand-
alone" Databases.

Did anyone know a Database, where i can use like MS Access (this means,
without needing to install a Database like mySQL or SQL Server) and has
more performance as MS Access? The last time i used MS Access (about 4
years ago) i had some performance Problems with more than 10.000 Datasets!

Thanks for your help or/and comments

Regards

Matthias

如果我需要绝对顶级性能而不安装像MSDE这样的东西

或者SQL Server，我会编写一个简单的二叉树系统并制作你自己的系统。

这是你获得优异性能的唯一方法。


你将遇到的问题不在于其他选项，

Access，FoxPro等是基于文件的系统; SQLServer也使用磁盘文件来存储数据。问题是访问方法;在访问基于文件的系统时，ODBC，ADO等只是在使用SQL Server，ADO等时太慢。

主要只是与服务器进行通信。 />

所以，虽然我建议将MSDE用于需要比Access更好的性能的客户端应用程序，如果这不是一种可能，请滚动你的

拥有。编写一个简单的，特定于应用程序的b树系统并不是很困难。您只需要一些方法：


搜索节点（递归），

添加节点，

删除节点，

分割一个节点

创建一个子节点


与那些，可能只是一些，你可以创建自己的节点闪电

快速，特定应用，数据库系统。


多年前，大约1990年或1991年，BYTE杂志写了一篇很棒的文章

你自己的b-tree系统。它包括大约10个函数的伪代码

，当时我构建了一个完整的数据库系统。我想b $ b假设现在不是很多帮助（快速搜索byte.com并没有提供这篇文章的b $ b）但肯定有'网上有类似的东西

。


Dale

" Matthias Kwiedor" < CR ******** @ hotmail.com>在消息中写道

新闻：Xn ********************************** @ 207.46 .2 48.16 ...

If I needed absolute top performance without installing something like MSDE
or SQL Server, I would write a simple binary tree system and make your own.
It is the only way you''re going to get great performance.

The problem you''re going to have isn''t in the fact that the other options,
Access, FoxPro, etc. are file based systems; SQLServer uses disk files to
store data too. The problem is the access methods; ODBC, ADO, etc. are just
too slow when accessing file based systems while, with SQL Server, ADO, etc.
mostly just communicates with the server.

So, while I recommend using MSDE for a client application that requires
better performance than Access, if that just is not a possibility, roll your
own. Writing a simple, application specific, b-tree system is not very
difficult. You only need a handful of methods:

Search a node (recursively),
Add a node,
Delete a node,
Split a node
Create a child node

with those and probably just a few more, you could create your own lightning
fast, application-specific, database system.

Years ago, circa 1990 or 1991, BYTE magazine had a great article on writing
your own b-tree systems. It included psuedocode for about 10 functions
that, at the time, I built upon to create a complete database system. I
suppose that''s not a lot of help now (a quick search of byte.com doesn''t
come up with the article) but certainly there''s something similar available
on the net.

Dale
"Matthias Kwiedor" <cr********@hotmail.com> wrote in message
news:Xn**********************************@207.46.2 48.16...

嗨！

在我目前的项目中，我使用MS Access作为数据库。我知道一些数据库，比如SQL Server，Oracle，mySQL和IBM的DB / 2，但不再是Stand-
。数据库。

有没有人知道数据库，我可以像MS Access一样使用（这意味着，无需安装像MySQL或SQL Server这样的数据库）并且有更多的数据库
性能如MS Access？我最后一次使用MS Access（大约4年前）我有超过10,000个数据集的性能问题！

感谢您的帮助或/和评论

Matthias

Hi!

In my current Project i use MS Access as Database. I know some Databases
like SQL Server, Oracle, mySQL and the DB/2 from IBM, but no more "Stand-
alone" Databases.

Did anyone know a Database, where i can use like MS Access (this means,
without needing to install a Database like mySQL or SQL Server) and has
more performance as MS Access? The last time i used MS Access (about 4
years ago) i had some performance Problems with more than 10.000 Datasets!

Thanks for your help or/and comments

Regards

Matthias

我遗漏了一个选项，因为我大约10年没用过任何一个选项了

我不知道现在有什么可以购买现有的B-tree软件包

for .Net。我假设有一些东西可以用。


等等......这就是你首先要求的，不是吗？


Dale

" Matthias Kwiedor" < CR ******** @ hotmail.com>在消息中写道

新闻：Xn ********************************** @ 207.46 .2 48.16 ...

One option I left out, because I haven''t used any for about 10 years and
don''t know what''s currently available is to buy an existing B-tree package
for .Net. I assume there are some to be had.

Oh wait... that''s what you asked for in the first place, isn''t it?

Dale
"Matthias Kwiedor" <cr********@hotmail.com> wrote in message
news:Xn**********************************@207.46.2 48.16...

嗨！

在我目前的项目中，我使用MS Access作为数据库。我知道一些数据库，比如SQL Server，Oracle，mySQL和IBM的DB / 2，但不再是Stand-
。数据库。

有没有人知道数据库，我可以像MS Access一样使用（这意味着，无需安装像MySQL或SQL Server这样的数据库）并且有更多的数据库
性能如MS Access？我最后一次使用MS Access（大约4年前）我有超过10,000个数据集的性能问题！

感谢您的帮助或/和评论

Matthias

Hi!

In my current Project i use MS Access as Database. I know some Databases
like SQL Server, Oracle, mySQL and the DB/2 from IBM, but no more "Stand-
alone" Databases.

Did anyone know a Database, where i can use like MS Access (this means,
without needing to install a Database like mySQL or SQL Server) and has
more performance as MS Access? The last time i used MS Access (about 4
years ago) i had some performance Problems with more than 10.000 Datasets!

Thanks for your help or/and comments

Regards

Matthias

这篇关于C＃数据库的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！