Although i get your point of view, and i appreciate your answer, i don't like to design my database on the assumption that there will be 100 records in it. If that would be the case, i wouldn't even bother asking for your advice/opinion in the first place.
On Tuesday, October 10, 2017 at 1:17:16 AM UTC+2, Marco Pivetta wrote: > > Why is everyone stuck with this silly performance question? > > Let's talk again when we have 100M+ records, shall we? Until then, it's > 16b vs 2b. > > The fact that you are using PHP is your first performance/memory > bottleneck. > > Marco Pivetta > > http://twitter.com/Ocramius > > http://ocramius.github.com/ > > On Mon, Oct 9, 2017 at 10:44 PM, <[email protected] <javascript:>> wrote: > >> I've recently stumbled on a Marco Pivetta's PHP Conf speech about >> Doctrine Best Practices and Tricks, >> and i really like solutions and the whole idea of immutability. >> >> Even tho, if one wants to achieve Immutability, he cant use >> auto-incremented integer strategy anymore, because it would break the >> immutability concept, and Uuid's come in handy here i understand it, but my >> concern is how it will affect my database performance, *and at the end >> of the day, would it be worth of implementing Uuid's just for the sake of >> immutability.* >> >> I don't have much experience in Uuid's but recently i've been researching >> this topic, and im aware that Sequenced Uuids exist, and they are much >> easier to index than totally random ones, but its still unclear to me, >> should i take this as solution to my business logic or not, because there >> are a lot of debate's on this topic on forums going back and forth, too >> many opinions and im unable to make decision. >> >> *Anyway, question is, is there big performance issues when it comes to >> reading and inserting data, also when working with joins and >> relationships,if i use Uuids, and also, what would be ideal implementation >> of them for sake of better performance ?* >> >> Btw im working in MySql, if that helps. Even tho i would really like to >> see Pivetta's answer, any help or answer would be highly appreciated. >> >> >> -- >> You received this message because you are subscribed to the Google Groups >> "doctrine-user" group. >> To unsubscribe from this group and stop receiving emails from it, send an >> email to [email protected] <javascript:>. >> To post to this group, send email to [email protected] >> <javascript:>. >> Visit this group at https://groups.google.com/group/doctrine-user. >> For more options, visit https://groups.google.com/d/optout. >> > > -- You received this message because you are subscribed to the Google Groups "doctrine-user" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at https://groups.google.com/group/doctrine-user. For more options, visit https://groups.google.com/d/optout.
