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


  • Anthony Dang 1404 posts 2558 karma points MVP 2x c-trib
    Feb 04, 2015 @ 11:31
    Anthony Dang
    0

    Umbraco's int primary keys

    We have a project which involves daily creations/updates of at 1000's of nodes per day.

    By my estimation, the cmsPropertyData table will grow at least 20 rows per node, and hence at least 100,000 rows per day.

    While this is not a major concern for at least a couple years, I'm curious about contingency.

    It would be good if Umbraco was using BigInt for primary keys. What are the implications of us changing the keys? I'm pretty sure I dont even wan to try this, but I'm just curious.

     

     

    Copy Link
  • Jeroen Breuer 4861 posts 12138 karma points MVP 3x admin c-trib
    Feb 04, 2015 @ 12:04
    Jeroen Breuer
    0

    I read a Twitter conversation a while ago that Umbraco will be switching to guids: https://twitter.com/Shazwazza/status/557801467550388224

    Jeroen

    Copy Link
  • Anthony Dang 1404 posts 2558 karma points MVP 2x c-trib
    Feb 04, 2015 @ 12:30
    Anthony Dang
    0

    I used to be pro-guid. These days i've come full circle and now hate them as it's hard to just eye-ball a guid, vs an int. 

     

    Copy Link

  • This forum is in read-only mode while we transition to the new forum.

    You can continue this topic on the new forum by tapping the "Continue discussion" link below.

Please Sign in or register to post replies