[FLOW3-general] UUID and performance on InnoDB

["Christian Müller (FLOW3 Team)"]

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

On 24/04/12 19:37, Alexander Berl wrote:
> Hello everyone,
>
> regarding uuids and innoDB databases: was it ever considered that uuid primary keys are relatively bad for indexing performance (and hence insertion/update/read) on innodb and if so, what was the reason to decide on that format for the identifier nonetheless? (see e.g. http://kccoder.com/mysql/uuid-vs-int-insert-performance/ or http://www.mysqlperformanceblog.com/2007/03/13/to-uuid-or-not-to-uuid/)
>
> Thanks in advance for any insight given.
>
> _________________________________________________________________________________________________________________________
> 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
>
>


-- 
Christian Mueller
TYPO3 Core Team

TYPO3 .... inspiring people to share!
Get involved: typo3.org