MySQL Forums
Forum List  »  Performance

Re: Find free appointments faster
Posted by: Peter Brawley
Date: November 14, 2017 10:19AM

> my very first idea would be to store the end of the interval by subtracting a smaller unit from the endtime

Very first ideas are often not so good as later ideas. A feature of the method is to remove any need to subtract token units.

SQL is not well designed for managing time data. If you're working more than occasionally with time, as you are, it's advisable to read about sql and time, the classic source is https://www2.cs.arizona.edu/~rts/tdbbook.pdf

Options: ReplyQuote


Subject
Views
Written By
Posted
2957
November 08, 2017 12:32AM
529
November 08, 2017 12:48AM
533
November 08, 2017 10:43PM
545
November 08, 2017 11:31PM
469
November 09, 2017 09:27AM
Re: Find free appointments faster
487
November 14, 2017 10:19AM
537
November 08, 2017 11:22PM


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.