Joomla 2.5 比 Joomla 1.5 Querywise 快得多吗

2022-01-06 00:00:00 php mysql joomla

我想知道 Joomla 2.5 是否比 Joomla 1.5 快得多.我不期望从页面内容、库或 motools 库等的加载中得到答案.我是从 mysql 查询的角度提出问题的……比如对于具有 4-500 万行的大型 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.

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

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!

  1. CMS 是旨在让您能够根据需要扩展网站的系统.
  2. 这样做,您可以开发扩展并继续添加内联查询!!!
  3. 当您显示 100 万条记录中的记录列表(比如每页 15 条记录)时.CMS 查询该表.
  4. 除了 #3,CMS 还在幕后运行许多其他查询,以执行其他内部任务,例如跟踪点击量、跟踪用户和后续工作.
  5. 除了 #4,可能还有其他几个模块和插件将在同一页面上运行,而不管您的执行标准如何,并且可能有更多的内联查询(遗憾的是,其中大多数运行了大量查询).
  6. 莉>

现在假设您有大约 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 数据库.您可以考虑增加系统变量,如 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.

相关文章