Daniel-Constantin Mierla writes:
Also, an index on connection_id would need to be created for location table.
there is already a connection_id in the database table location? Or do you mean something else?
Yes, but no index on it. Without an index, it may take a long time to delete a record based on connection_id.
-- Juha