[Logo] Terracotta Discussion Forums (LEGACY READ-ONLY ARCHIVE)
  [Search] Search   [Recent Topics] Recent Topics   [Members]  Member Listing   [Groups] Back to home page 
[Register] Register /  [Login] Login 
[Expert]
Question about Quartz MySQL tables primary key - isn't it too long?  XML
Forum Index -> Quartz
Author Message
[Post New]10/10/2013 02:05:43
    Subject: Question about Quartz MySQL tables primary key - isn't it too long?
[Up]
vitalyk

neo

Joined: 10/10/2013 01:58:56
Messages: 2
Offline
When I reviewed SQLs for creation Quartz tables for MySQL, I saw that primary key are pretty long (520 bytes).
As far as I know, MySQL guides to use short primary keys for InnoDB tables for improving performance.
Did someone try to modify Quartz schema and compare performance?

TIA,
Vitaly
[Post New]10/11/2013 06:18:10
    Subject: Re:Question about Quartz MySQL tables primary key - isn't it too long?
[Up]
jhouse

seraphim
[Avatar]
Joined: 11/06/2009 15:29:56
Messages: 1703
Offline
You can use any size you want - so long as it is long enough for whatever names you are giving to your triggers/jobs etc.
[Post New]10/12/2013 22:52:35
    Subject: Re:Question about Quartz MySQL tables primary key - isn't it too long?
[Up]
vitalyk

neo

Joined: 10/10/2013 01:58:56
Messages: 2
Offline
thank you!
 
Forum Index -> Quartz
Go to:   
Powered by JForum 2.1.7 © JForum Team