MySQL或SQL Server更适合企业应用程序?

我正在使用PHP开发一个大型应用程序。 MySQL或SQL Server是最好用的吗? </ p>
</ div>

展开原文

原文

I am developing a big application using PHP. Is MySQL or SQL Server the best one to use?

douduonang3169
douduonang3169 toolong
11 年多之前 回复

9个回答

MySQL and PHP work well together. I'd recommend that combination.

I'd much rather choose an open-source solution rather than rely on MS. That said, you can go with PostgreSQL as well if you need to, or your requirements gear you toward it. We would need more details to know what you truly require.

dongwaner1367
dongwaner1367 我不知道它们如何比PHP / MSSQL更好地协同工作。 我唯一能想到的是使用MSSQL和PHP的教程较少且支持较少,但如果OP知道他在做什么,这不是什么大问题。
11 年多之前 回复
dt56449492
dt56449492 too long
11 年多之前 回复



MySQL和SQL Server Express可免费用于生产。 在我看来,最好的建议是尝试两者并自己决定。 很多人都可以用轻量级的RDBMS来生活,其中像MySQL / Express这样的解决方案可能是合适的。</ p>

从纯粹的技术角度来看,所有主要的RDBMS供应商(Oracle,Sybase) ,DB2,SQL Server等人的功能远远超过MySQL目前或可以合理预期在可预见的未来。 </ p>

不</ em>意味着你不应该将MySQL用于特定的工作。 一个很好的类比是继续使用多年前发布的Microsoft Office版本。 对于大多数人来说,旧版本可以完成他们想要的一切,即使新版本“更好”并且具有更多功能。</ p>
</ div>

展开原文

原文

MySQL and SQL Server Express are free for production use. In my view the best advice is to try them both and decide for yourself. A lot of folks can live quite happily with a lightweight RDBMS where solutions like MySQL/Express may be appropriate.

From a purely technical point of view all of the major RDBMS vendors (Oracle, Sybase, DB2, SQL Server et al.) are significantly more capable than MySQL is currently or can reasonably be expected to be in the foreseeable future.

This does not mean you should not use MySQL for a particular job. A good analogy is continuing to use a version of Microsoft office released years ago. For most people the old version does everything they would ever want even though the newer version is "better" and has more features.

Use the one you and your team has most experience in terms of both development and administration.

If you start from scratch, I would go with PostgreSQL.

Between your choices I would go for SQL Server, especially if you are working in Windows environment.



两者都没有。 使用PostgreSQL。 :)</ p>

老实说,PostgreSQL比MySQL更好。 我不知道你对“企业”的意思,但我觉得缩放对于一个“大”的Web应用程序很重要,就像你说的那样,PostgreSQL做得非常好。 MySQL无法处理太多的并发连接。 (虽然如果这对您来说不是问题,请使用MySQL以方便使用。)</ p>
</ div>

展开原文

原文

Neither. Use PostgreSQL. :)

Honestly though, PostgreSQL scales much better than MySQL. I don't know what you mean by "enterprise", but I figure scaling is important for a "big" web application, as you put it, and PostgreSQL does that very well. MySQL can't handle too many concurrent connections. (Though if that isn't an issue for you, go with MySQL for ease of use.)



虽然这有点主观,但我建议选择MySQL。</ p>

我之所以这样做 说这是因为传统上你会看到人们使用LAMP设置。 LAMP当然是Linux + Apache + MySQL + PHP </ p>

PHP有一些很好的内置功能来处理MySQL数据库,因此它可能更容易。 然后,您还可以使用PhpMyAdmin将Web界面绑定到数据库来进行基于Web的工作</ p>
</ div>

展开原文

原文

While this is a bit subjective, I would suggest going with MySQL.

The reason I say this is because traditionally you see people go with a LAMP setup. LAMP of course being Linux + Apache + MySQL + PHP

PHP has some great build in functionality for dealing with MySQL Databases, therefore it may be easier for you. Then you'll also have the ability to do some web based work with PhpMyAdmin tying a web interface to your Database



MySQL使用PHP肯定更好。 但MS正在努力在Windows平台上更好地支持PHP。</ p>

SQL Server绝对是大型企业解决方案的最佳选择,因为它有更好的集群和管理支持。 我们使用MySQL是出于成本原因,但我真的想要一些更简单的管理和集群支持。</ p>

另一方面,它与计算机一样:如果它们符合您的需求,您需要比较许多功能 - 和你的钱包。</ p>

如果你正在做一个单人秀:离开SQL Server。 它只适合企业。 以MySQL或PostgreSQL为例。</ p>
</ div>

展开原文

原文

MySQL is certainly better to work with PHP. But MS is putting a huge effort in better supporting PHP on Windows platforms.

SQL Server is DEFINITELY the better choice for large enterprise solutions since there's better cluster and management support. We use MySQL for cost reasons, but i would really like some easier management and cluster support.

On the other hand it's like with computers: many features you need to compare if they suit your needs - and your purse.

If you are doing a one-man-show: Step away from SQL Server. It is only suitable for enterprises. Take MySQL or PostgreSQL.

drb0901500211
drb0901500211 不。 我确实谈过SQL Server,而不是SQL Server Express - 抱歉没有说清楚。 MS SQL Server Express适合初学者和爱好程序员。 但是,如果您想管理大量数据,使用多CPU系统等,则需要使用SQL Server,MySQL或PostgreSQL等“全面”数据库系统。
大约 11 年之前 回复
duanrong5167
duanrong5167 too long
大约 11 年之前 回复

For most IT directors a big decision is going to be which can you get the best support for in your area / online / already have in-house and which can you get the most uptime for. Ongoing costs are usually higher than deployment costs so its probably not worth worrying about license costs; unless you are into ia64 or better type systems anyway when the CPU count starts to make SQL look eye-wateringly expensive.



这取决于您的应用程序的需求。 我对各种SQL引擎之间的差异没有特别好的研究,但据我所知,MySQL查询的速度更快(如果你有一个主要是只读类型的应用程序)。 另一方面,MSSQL和PostgreSQL都有更好的事务支持,如果你有大量的插入/更新,也可能有更好的性能。 此外,据说MSSQL和PostgreSQL可以更好地扩展,但有各种成功的应用程序似乎可以正常使用MySQL(Facebook和Flickr作为示例)。</ p>
</ div>

展开原文

原文

It will depend on your application's needs. I'm not especially well researched on the differences between the various SQL engines, but as far as I know, MySQL is faster for SELECT queries (if you have a predominantly read-only type app). On the other hand, MSSQL and PostgreSQL both have better support for transactions, and perhaps also better performance if you have lots of inserts/updates happening. Also, MSSQL and PostgreSQL are said to scale better, but there are various successful applications that seem to do fine with MySQL (Facebook and Flickr as examples).



这就像决定要使用什么样的计算机一样,无论你挑选什么品牌,它们现在几乎都是一样的。 它对于数据库来说几乎是一样的,它们都支持轻量级Web应用程序所需的大部分内容。 </ p>

到目前为止,我已经将MySQL用于我的所有php应用程序,并且没有任何问题。 我想多次测试PostgreSQL,但从来没有尝试过,但我听说过很好的事情。 我从来没有接触过MS产品,所以没有意见(不是说我过敏,我只是吝啬。)。 </ p>
</ div>

展开原文

原文

It's like deciding what computer to get, they are by now pretty much the same no matter what brand you pick. It's pretty much the same for databases, they all support most of the things that you need for lightweight webapplications.

I have used MySQL to all my php applications so far and had no problems whatsoever. I have wanted to test out PostgreSQL several times but never got to it, but I have heard very good things about it. I never touch MS products however, so no opinion (Not that I am allergic, I'm just stingy.).

Csdn user default icon
上传中...
上传图片
插入图片
抄袭、复制答案,以达到刷声望分或其他目的的行为,在CSDN问答是严格禁止的,一经发现立刻封号。是时候展现真正的技术了!
立即提问
相关内容推荐