Juha Heinanen writes:
If it is, may be its value could be made available to the event route in a pseudo variable.
Also, an index on connection_id would need to be created for location table. Is connection_id unique or can there be duplicates? If unique, the index could be unique too.
This index is needed also if connection id is stored and hash table. Can the index still be added? In my opinion, yes, because otherwise connection_id column is of no use in db only mode.
-- Juha