Change
Remove type-instance from associations
Issue description
In a store of 1 mio topics there is 1 mio associations and 2 mio roles which are hardly ever used. Consider removing the persisting of the type instance association.
Developer comments
The system should keep its current behavior with a few minor technical changes under the hood, but it should be possible to process topic maps with %instance_of% at the %topic%. Initially %instance_of% should be added when reading, this will make it easier for the JavaScript components to determine the type of a topic. Later it should be also possible to use it for writing.
Plan to adjust the table structure:
* Create a unique constraint on (type, instance).
* Drop the foreign key constraint on association_id.
* Rename association_id to id, set autoincrement to max.
|
Work sessions13
Start |
2019-09-28T07:14:23
|
End |
2019-09-28T07:41:59
|
Participant |
Robert Cerny
|
Start |
2019-09-29T07:09:52
|
End |
2019-09-29T09:42:48
|
Participant |
Robert Cerny
|
Start |
2019-09-29T12:18:20
|
End |
2019-09-29T15:20:35
|
Participant |
Robert Cerny
|
Start |
2019-09-29T16:49:39
|
End |
2019-09-29T17:49:47
|
Participant |
Robert Cerny
|
Start |
2019-09-29T19:00:00
|
End |
2019-09-29T20:25:24
|
Participant |
Robert Cerny
|
Start |
2019-09-30T06:18:34
|
End |
2019-09-30T08:19:10
|
Participant |
Robert Cerny
|
Start |
2019-09-30T08:46:39
|
End |
2019-09-30T09:01:28
|
Participant |
Robert Cerny
|
Start |
2019-09-30T14:36:27
|
End |
2019-09-30T16:15:45
|
Participant |
Robert Cerny
|
Start |
2019-10-01T10:36:04
|
End |
2019-10-01T14:19:12
|
Participant |
Robert Cerny
|
Start |
2019-10-01T15:39:11
|
End |
2019-10-01T17:54:45
|
Participant |
Robert Cerny
|
Start |
2019-10-02T06:43:02
|
End |
2019-10-02T08:25:31
|
Participant |
Robert Cerny
|
Start |
2019-10-02T12:42:24
|
End |
2019-10-02T14:13:41
|
Participant |
Robert Cerny
|
Start |
2019-10-03T07:51:41
|
End |
2019-10-03T08:11:53
|
Participant |
Robert Cerny
|
|
We are sorry
This page cannot be displayed in your browser. Use Firefox, Opera, Safari, or Chrome instead.