MySQL Forums
Forum List  »  Stored Procedures

Advanced Search
New Topic

Re: Insert on time difference greater than
Posted by: Peter Brawley
Date: May 17, 2016 12:44PM

They're stored procedures, not storage procedures.

To optimise the query that looks for the most recent insert per-receiver, you'll probably need a covering index (tag_number,receiver).

Navigate: Previous Message• Next Message
Options: Reply• Quote


Subject
Views
Written By
Posted
Insert on time difference greater than
2935
Manny B
May 17, 2016 11:21AM
Re: Insert on time difference greater than
884
Peter Brawley
May 17, 2016 11:28AM
Re: Insert on time difference greater than
779
Manny B
May 17, 2016 11:44AM
Re: Insert on time difference greater than
904
Peter Brawley
May 17, 2016 12:44PM
Re: Insert on time difference greater than
992
Rick James
May 24, 2016 10:37AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.