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