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 3x 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 4908 posts 12265 karma points MVP 5x 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 3x 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
Please Sign in or register to post replies

Write your reply to:

Draft