Joomla 2.5是否比Joomla 1.5 Querywise快得多 [英] Is Joomla 2.5 much faster than Joomla 1.5 Querywise

问题描述

我想知道Joomla 2.5是否比Joomla 1.5快得多.我不希望从页面内容，库或motools libs等的加载中得到答案.我是从mysql查询的角度来询问...像一些联接查询，多查询等，用于具有4-5百万行的大型mysql表?

I wanted to know if Joomla 2.5 is much faster than Joomla 1.5. I am not expecting answers from the loading of the page content, libraries or motools libs etc. I am asking from the point of mysql queries...like will some join queries, multi queries etc for large mysql tables with 4-5 million rows?

我正在开发一个求职门户，我已经拥有一个500万求职者的数据库...并且某些查询需要很长时间才能执行或出现致命错误(已分配内存).所以我想知道Joomla 2.5是否可以更好地满足我的目的?

I am developing a job portal for which i already have a database of 5 million jobseekers...and some queries take long time to execute or gives the Fatal error (memory allocated). So i was wondering if Joomla 2.5 would better serve my purpose?

推荐答案

如果您有数百万条记录，则两个版本是相同的.

Both versions are same if you have millions of records.

让我告诉您，为什么当您的网站增长并且数据库变得像500万条记录一样庞大时，CMS(Joomla和Wordpress等)会为您提供服务器超时！

Let me tell you why CMS (Joomla and Wordpress and likes) give you server timeouts when your website grows and the database becomes as giant as 5mn records!

CMS是为使您有能力在需要时扩展网站而开发的系统.
1. 这样做，您可以开发扩展并继续添加内联查询！！
2. 当您显示100万条记录中的记录列表(例如每页15条记录)时. CMS查询该表.
3. 与#3一起，CMS在幕后运行许多其他查询，以执行其他内部任务，例如跟踪点击次数，跟踪用户和儿子.
4. 与#4一起，可能有多个其他模块和插件将在同一页面上运行，而不管您的执行标准如何，并且可能会有更多的内联查询(其中大多数查询会运行很多查询).

1. CMS are systems that are developed to give you power to extend your website as a need arises.
2. Doing so, you develop extensions and keep on adding inline queries!!!
3. When you display a list of records (say 15 records per page) out of your 1mn records. CMS queries that table.
4. Along with #3, CMS runs many other queries behind the curtain to do other internal tasks such as tracking the hits, tracking the user and son on.
5. Along with #4, there might be several other Modules and Plugins that will be running on the same page regardless of your criteria of execution and may have some more inline queries (most of them sadly run lot of queries).

现在假设您有大约100个用户.加载与我在1-5上写过的页面相同的页面.假设此方案执行约10个mySQL查询，然后想象一下，如果一次有100个用户，将执行多少个查询?

Now assume you have about 100 users. Came to load the same page for which I wrote above 1-5. Say this scenario executes about 10 mySQL queries then imagine how many would be executed if you have 100 users at a time?

当您拥有如此大的数据库时，则必须实现负载平衡.现在，如果您有权访问MySQL数据库的配置，则可以对其进行优化.您可能会考虑增加sysvar，例如max_connections等.

When you have such large database - then you must implement load balancing. For now you can optimize your MySQL database if you have access to its configuration. You may look into increase sysvars like max_connections etc.

好吧，负载平衡"不是升级硬件，而是整个系统和工作流程，可以帮助您最大程度地实现目标.自从您在评论中提出问题后，我希望人们知道这是什么意思，因此请在我的回答中使其更加清楚.

由于服务器超时，并且由于数据库中有数百万条记录，因此您必须考虑以下网站上说明的问题:

Since you are having server timeout and its because of several million records in your database then you must think about something explained at following web locations:

http://en.wikipedia.org/wiki/Load_balancing_%28computing%29

http://technet.microsoft.com/en-us/library/bb742455.aspx

他们可能会帮助您了解我在说什么(可能不在主题之列)，但您必须认真研究如何分布数据库或网站上的负载，以便您可以让他们快速执行查询.

They might help you understand what I am talking about (could be off the topic) but you must seriously look into the possibilities how you could distribute your database or the load on your website so that you can allow them to execute queries quickly.

这篇关于Joomla 2.5是否比Joomla 1.5 Querywise快得多的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！