Sign in Register
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
    1

    What happens when you max out on integer IDs?

    Using Umbraco And Getting Started
    Umbraco 7

    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?

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

    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 :-)

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

    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 :)

    Copy Link
Please Sign in or register to post replies

Write your reply to:

Draft