ID 456727 - DB upgrade to v28 can take a very long time

Follow

Problem summary
Upgrading Flix to 6.3.5 requires a database upgrade that can take a very long time, depending on how many rows the vDialogue and sequence_dialogue tables contain.
 
Customer reported version
6.3.3 > 6.3.5
 
Customer reported platform
CentOS 7
 
Steps to reproduce
1) In a pre-6.3.5 database (db version 26 or earlier), have 500.000 rows or more in sequence_dialogue and/or vDialogue.
2) Point the 6.3.5 Flix Server to that database and follow the prompts to upgrade.
 
Expected behaviour
Database upgrade should take a reasonable amount of time (a few hours perhaps).
 
Actual behaviour
Database upgrade can potentially take days.

    We're sorry to hear that

    Please tell us why