Copied to clipboard

Flag this post as spam?

This post will be reported to the moderators as potential spam to be looked at

  • Mikkel Johannsen 32 posts 185 karma points
    Feb 20, 2019 @ 21:47
    Mikkel Johannsen

    What happens when you max out on integer IDs?

    Hello Umbracians

    I'm curious... In theory, what happens if you max out on maximum number of integers? If you use all 2,147,483,647 of them.

    I'd assume you simply won't be able to create any more nodes, but I'm curious if there's any built-in security mechanism to e.g. start using old, unused IDs or anything similar?

    And theoretically, would there be any way at all to protect your system from this?

  • Søren Gregersen 441 posts 1883 karma points MVP 2x c-trib
    Feb 20, 2019 @ 22:34
    Søren Gregersen

    There is no re-use or any overflow protection, other than what the datastore (MSSQL etc) gives. It will just fail.

    But... you either have some code creating nodes, or some very productive editors ;-)

    I would’nt worry about hitting this limit, and if you are, maybe you need to store the data outside the umbraco tables :-)

  • Mikkel Johannsen 32 posts 185 karma points
    Feb 20, 2019 @ 22:48
    Mikkel Johannsen

    Hi Søren

    Thanks for your reply.

    I'm not too worried about it either, I was just wondering since Content, Media, Members and DataTypes all seem to increment from the same ID :)

Please Sign in or register to post replies

Write your reply to: