加载缓慢、1502 个查询和会话中的大量数据 - 请参阅调试日志
我已经尝试调试我的网站有一段时间了，我发现对于每个页面，系统都在执行大量查询，并且存储在会话中的数据已达到在数据库中编码的近一百万个字符。
该网站正在使用 joomla 和 Virutmart 的电子商务。这超出了正常范围，我尝试禁用除 Virtuemart 之外的所有模块、插件和组件。
有人可以帮我弄清楚这些查询来自哪里以及如何减少它们。我需要知道如何找出会话中充满了所有这些信息的内容。
查看此链接并查看页面底部的调试日志。
谢谢
链接：我的网站< /a>
I've been trying to debug my site for some time now and I see that for every page the system is doing large amount of queries and data which is stored in session has reached almost a million characters that are encoded in the db.
The site is using joomla with ecommerce from virtuemart. This is way beyond normal and I have tried disabling all modules,plugins and components except Virtuemart.
Can someone please help me figure out where these queries are coming from and how to reduce them. I need to know how I can find out what is filling the session with all this information.
Check out this link and take a look at the debug log on the bottom of the page.
Thank you
Link: My site
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（1）
看起来您的系统在一个查询中分别加载每种产品的数据。该页面上有很多产品。
同样的问题，例如在magento中。
如果您“过于面向对象”，这就是权衡。
恐怕如果不改变系统的内部结构，你就无能为力。
您可能需要考虑切换到另一个更注重性能的商店系统。
据我所知，oxy 很好，而且我已经看到了一些令人信服的基准测试和加载模式。
优化当前系统的其他“更高层”方法是
looks like your system loads the data for each products seperately in one query. and there are a lot of products on that page.
same problem for example in magento.
thats the tradeoff if you get "too object oriented".
im afraid theres nothing much you can do about it without changing the guts of your system.
you may want to consider switching to another shop system that is more focused on performance.
oxid is good from what ive heard, and i've seen some convincing benchmarks and loading patterns.
other "higher layer" approaches to optimize your current system are