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