[FLOW3-general] UUID and performance on InnoDB

[Alexander Berl]

Hi Christian,

Thanks for the answer. Makes sense and I wasn't aware you can easily override the identifier type, so it's a non-issue for hard performance needs.

Cheers back,
Alexander

> Hi,
>
> this was not a decision that was taken with databases in mind but first with usability for coding. UUIDs are the better identifiers for entities and their portability across tables/systems is much better. So that was the primary concern. Even though probably MySQL will be the main database system in use there are many others of which some probably don't share this weakness. And seeing the dataset in the example I think this is flaw will not be noticeable in many real world applications, they will have stronger servers and probably less inserts.
>
> Additionally if you have a high insert table and clearly need this performance plus you can always define your own Id for a model and make it an auto-incrementing integer.
>
> Cheers,
> Christian
>
> --
> Christian Mueller
> TYPO3 Core Team
>
> TYPO3 .... inspiring people to share!
> Get involved: typo3.org

_________________________________________________________________________________________________________________________
Alexander Berl
Senior Developer

We're hiring!<http://www.eol.de/jobs>

EOL Group GmbH
Siemensstraße 3
35463 Fernwald-Annerod
Germany

Tel.:     +49 (0) 641 46092 - 0
Mobil:   +49 (0) 172 6376384
Fax:      +49 (0) 641 46092 - 199

E-Mail:  a.berl at eol.de<mailto:a.berl at eol.de>
Web:    www.eol.de<http://www.eol.de/>
Der Inhalt dieser E-Mail (einschließlich etwaiger beigefügter Dateien) ist vertraulich und nur für den Empfänger bestimmt. Sollten Sie nicht der bestimmungsgemäße Empfänger sein, ist Ihnen jegliche Offenlegung, Vervielfältigung, Weitergabe oder Nutzung des Inhalts untersagt. Bitte informieren Sie in diesem Fall unverzüglich den Absender und löschen Sie die E-Mail (einschließlich etwaiger beigefügter Dateien) von Ihrem System.
Vielen Dank.

The contents of this e-mail (including any attachments) are confidential and may be legally privileged. If you are not the intended recipient of this e-mail, any disclosure, copying, distribution or use of its contents is strictly prohibited, and you should please notify the sender immediately and then delete it (including any attachments) from your system.
Thank you.

EOL Group GmbH
Sitz der Gesellschaft: Fernwald
Geschäftsführer: Alexander Anhuth
Amtsgericht Gießen HR B 7063
USt.-IdNr: DE266484182