MS SQL或MYSQL [英] MS SQL or MYSQL

问题描述

嘿伙计即将开始一个大项目，我想知道什么是

数据库服务器使用

我有选择MySql（innodb）或者我支付了有点额外我可以得到MS SQL

2000

我有的担忧

-我将使用MYSQL来实现什么类型的有限功能

即没有存储的POCS

-使用innodb的RDBMS系统的限制


速度

但是使用MYSQL而不是MS SQL2K需要多少代码


谢谢供您输入

Hey guys im about to start a large project and am wondering what
DB server to use
I have the Choise of MySql(innodb) or if i pay a bit extra i can get MS SQL
2000
The concerns i have
-What type of limited functionality will i come accros with MYSQL
ie No stored POCS
-Limitations with the RDBMS system of innodb

If i go with MySQL + Innodb i think this will be offer the fastest runtime
speed
but how much more code am i going to need using MYSQL rather than MS SQL2K

Thanks for your input

推荐答案

我的SQL是一个很棒的数据库服务器。但是，SQL Server 2000肯定会更好，并且CLR中有本机SQL Server类，它们极大地增强了对SQL Server数据库的性能。更不用说下一个版本的SQL Server将会非常棒。


-

HTH，


Kevin Spencer

..Net开发人员

Microsoft MVP
http://www.takempis.com

大项目组成

$ b" Vincent V"
" < [e-mail]>在消息中写道

新闻：ee ************** @ TK2MSFTNGP11.phx.gbl ...

My SQL is a great database server. However, SQL Server 2000 is definitely
better, and there are native SQL Server classes in the CLR, which enhance
performance against a SQL Server database tremendously. Not to mention the
fact that the next version of SQL Server is going to be just plain awesome.

--
HTH,

Kevin Spencer
..Net Developer
Microsoft MVP
http://www.takempis.com
Big things are made up
of lots of little things

"Vincent V" <[e-mail]> wrote in message
news:ee**************@TK2MSFTNGP11.phx.gbl...

嘿伙计即将发布开始一个大项目，我想知道什么是数据库服务器使用
我有选择MySql（innodb）或者如果我支付额外的费用我可以获得MS
SQL 2000
我关心的问题 - 我将使用MYSQL来实现什么类型的有限功能
即没有存储的POCS
- 与innodb的RDBMS系统的限制
如果我与MySQL + Innodb一起使用我认为这将提供最快的运行时间
但是我需要使用MYSQL而不是MS SQL2K需要多少代码

感谢您的支持输入

Hey guys im about to start a large project and am wondering what
DB server to use
I have the Choise of MySql(innodb) or if i pay a bit extra i can get MS SQL 2000
The concerns i have
-What type of limited functionality will i come accros with MYSQL
ie No stored POCS
-Limitations with the RDBMS system of innodb

If i go with MySQL + Innodb i think this will be offer the fastest runtime
speed
but how much more code am i going to need using MYSQL rather than MS SQL2K

Thanks for your input

在MySql页面中 http://www.mysql.com/products/mysql/index.html

说出其他的东西：


简而言之，* current * version ... <支持所有这些br>

In the MySql page http://www.mysql.com/products/mysql/index.html
say other things:

In short say that all this is supported in the *current* version...

1.查看
2.外键
3.子查询
4.交易

1. View
2. Foreign key
3. Sub Query
4. Transaction

好吧，


他们可以称之为交易，但我不会。

想法是如何将数据写入存储以及后来如何交易，但不是应用程序如何实现它。

因此，在设计数据库时 - 交易应该是

开头的东西，但没有添加到文本上面

文件引擎。

因此，特别是对于更关键的应用程序，MySQL

不应该是选项。

虽然，没有什么是个人的，如果你使用

它我会很好。你也可以。 br />

Romualdas

Well,

They can call it transaction, but I wouldn''t.
The idea is how the data is written to the storage and how
it is later transacted, but not how the app implements it.
So, when designing DB''s - the transaction should be
something started with, but not added on top of the text
file engine.
Therefore, especially for more critical apps, MySQL
shouldn''t be the option.
Though, nothing personal and I''m very OK if you are using
it and it is OK for You.

Romualdas

-----原始消息-----
在MySql页面中
http://www.mysql.com/products/mysql/index.html 说其他事情：
简而言之，* current *
版本支持所有这些......

-----Original Message-----
In the MySql page http://www.mysql.com/products/mysql/index.htmlsay other things:
In short say that all this is supported in the *current* version...

1.查看
2。外键
3.子查询
4.交易

1. View
2. Foreign key
3. Sub Query
4. Transaction

这篇关于MS SQL或MYSQL的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！