PhpBB论坛会话问题
嗨朋友们，我已经使用phpBB为我的网站设置论坛，但实际上现在我们面临一个大问题，即其中的session表。这个表充满了数据就像任何事情一样，即使我们清除它，它也会在一夜之间被填满，因为我们确实有大量的访问者，但是否有任何规定可以禁用会话记录实际上是phpBB检查的一些地方对于该表中的数据。托管公司已通知我们此查询是杀手！
SELECT * FROM `session`
由于数据量巨大，此查询会减慢网站速度，因此我们将不胜感激，
谢谢
Hi friends i have used phpBB for setting the forum for my site , but actually now we face a big problem ie, the session table in that.This table is filled with data like anything even we clear it , it become fill overnight it we do have a huge of visitors, but is there any provision to disable the session recording actually some where the phpBB checks for data in that table. we have been notified by the hosting company that this query is a killer!
SELECT * FROM `session`
This query slows down the site because of the huge amount of data so any help will much appreciated
Thanks
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（1）
每个访问您的 Phpbb 论坛的用户都将始终在会话表中获得自己的会话行。但一旦会话过期，这些行就会被删除。因此，会话表永远不应该填满，尽管您可能想在 Phpbb 管理器中检查会话超时值。
（如果您从共享主机帐户运行此程序，则很难从 Phpbb 获得任何下降性能，因为该软件是非常选择查询密集型的，并且大多数共享主机帐户不为其提供足够的 MySql 性能）。
Each and every user visiting your Phpbb forum will always get its own session row in the session table. But these rows are removed as soon as the sessions expire. So the sessions table should never fill up, although you might want to check your session time-out value in the Phpbb administrator.
(If you are running this from a shared hosting account, it’s very hard to get any descent performance out of Phpbb as the software is very select query intensive and most shared hosting account don’t offer adequate MySql performance for it).