vB5 Memory Errors

[Mark.B]

There is no instant answer to your question. As soon as we have something we will respond.

[ShannonA]

There is no instant answer to your question. As soon as we have something we will respond.

Not instant, I can understand, but that was eight days ago.

Seriously, I wasn't being passive aggressive: we're moving from vB4 to XenForo, so don't worry about me at this point.

[Wayne Luke]

I am sorry for the delay in replying. We're working on some issues with displaying large node trees. https://tracker.vbulletin.com/vbulle...sues/VBV-17204

I believe this can help your overall system performance when displaying topics. Currently, this change is planned for 5.5.0 which will be released early next year. For an idea of the change that is being implemented here, it involves a single topic with 650,000 posts. Currently that takes 540 MB to display. With the changes for this issue, the same topic takes 140 MB to display. That is a substantial gain. This involves how data is handled in PHP and should also result in a performance benefit.

Was the SQL above using a file or key sort?

[Wayne Luke]

I believe this is the query:
SQL Query #115


SELECT DISTINCT node.starter AS nodeid FROM vb_node as node LEFT JOIN vb_node AS starter ON starter.nodeid = IF(node.starter = 0, node.nodeid, node.starter) LEFT JOIN vb_sentto AS sentto ON node.nodeid = sentto.nodeid AND sentto.userid = 1 AND sentto.deleted = 0 WHERE starter.sticky = '1' AND node.contenttypeid <> 23 AND node.parentid = 3 AND node.inlist = 1 AND ( node.contenttypeid <> 27 OR sentto.nodeid IS NOT NULL) AND node.protected <> '1' ORDER BY starter.lastcontent DESC,node.nodeid ASC /**getSearchResults**/

1	SIMPLE	node		ref	node_parent,node_starter,node_ctypid_userid_dispo_idx, contenttypeid_parentid,node_inlist	node_parent	4	const	9	42.00	Using where; Using temporary; Using filesort
1	SIMPLE	starter		eq_ref	PRIMARY,node_sticky,nodeid	PRIMARY	4	func	1	5.00	Using where; Distinct
1	SIMPLE	sentto		ref	PRIMARY,nodeid,user_read_deleted	PRIMARY	8	vb5_dev.node.nodeid,const	1	100.00	Using where; Distinct

• Time Before: 1541717952.1257
• Time After: 1541717952.1262
• Time Taken: 0.00050997734069824
• Memory Before: 23068672
• Memory After: 23068672
• Memory Used: 0

[Wayne Luke]

I have created a bug issue to have our developers to look into the issue further. https://tracker.vbulletin.com/vbulle...sues/VBV-18916