XF 2.2 Max nodes

[Ricsca]

Is there a maximum number of nodes a xenforo forum can have?
Thansk

 

[Kirby]

2147483647 nodes.

Though more realistically I probably wouldn't want to have more than 2K nodes.

 

[Ricsca]

can i ask you where you found this number?

 

[Rusty Snippets]

That’s a phone number lol

 

[philmckrackon]

2147483647 nodes.

Though more realistically I probably wouldn't want to have more than 2K nodes.

Um more than any budget of any county?

Actually it's the Mersenne prime.

2,147,483,647 - Wikipedia

en.m.wikipedia.org

 

[Kirby]

can i ask you where you found this number?

xf_node.node_id is a auto increment signed int and that is the maximum value a int can store.

MySQL :: MySQL 8.4 Reference Manual :: 13.1.2 Integer Types (Exact Value) - INTEGER, INT, SMALLINT, TINYINT, MEDIUMINT, BIGINT

dev.mysql.com

So unless you want to modify the schema this would be the maximum number of nodes.

 

[Xon]

xf_node.node_id is a auto increment signed int and that is the maximum value a int can store.

MySQL :: MySQL 8.4 Reference Manual :: 13.1.2 Integer Types (Exact Value) - INTEGER, INT, SMALLINT, TINYINT, MEDIUMINT, BIGINT

dev.mysql.com

So unless you want to modify the schema this would be the maximum number of nodes.

xf_node.node_id should be an unsigned int which should have a max value of 4294967295.

However, if you are using 32bit php (which XenForo generates a warning about in the enviroment report) then the max integer value that php can handle is 2147483647 without something going wrong.

 

[Kirby]

xf_node.node_id should be an unsigned int.

Yup, it is.

I only looked at XF\Install\Data\Mysql.php and that had no unsigned (as that is set implicitly) - my mistake, sorry.

 

[Xon]

XF switched to implicitly unsigned in XF2 but was somewhat inconsistent in XF1.x.

That said, I had some fun with autoincrement running out of ID space after some out of control processes exhausted the IDs and caused some transactions to silently fail!

Though more realistically I probably wouldn't want to have more than 2K nodes.

Even a few hundred gets seriously painful due to the pain that is the standard <select> element and having all of them listed with no way to easily filter/search them.