-
|
I want to set the multi-field index, but I can't find the instructions |
Beta Was this translation helpful? Give feedback.
Replies: 4 comments
-
|
Zserio language does not support SQLite indexes at all, so unfortunately this is not possible. |
Beta Was this translation helpful? Give feedback.
-
|
Shouldn't this work by using the sql keyword similiar to how the primary key is specified here: https://github.com/ndsev/zserio/blob/master/doc/ZserioLanguageOverview.md#sqlite-tables |
Beta Was this translation helpful? Give feedback.
-
|
Yes, if there is a need to support SQLite indexes, we will probably implement it as you wrote. We just did not get any request to support SQLite indexes so far, so we have decided not to implement them to save effort. |
Beta Was this translation helpful? Give feedback.
-
|
A note from past experience: Setting a SQL index during schema generation time is in almost all cases not optimal, as it heavily depends on the filling of a table later on how you can optimze performance by adding indexes. |
Beta Was this translation helpful? Give feedback.
A note from past experience: Setting a SQL index during schema generation time is in almost all cases not optimal, as it heavily depends on the filling of a table later on how you can optimze performance by adding indexes.
That is why we have not implemented them in zserio so far.