Re: storing username
Posted by: Peter Brawley
Date: September 27, 2014 12:50AM

Do the arithmetic. An enum column with 5 values spread more or less equally across, say, 50k rows will have 10k dupes of each value. An index on that will speed up nothing.

> calendar works only with UNIX timestamps

Which you could insert with from_unixtime(...) and retrieve with unix_timestamp(...). IAC int(50) is gibberish.

But why reinvent the wheel? There are lots of robust appointment schemas, see http://www.databaseanswers.org/data_models/.

Options: ReplyQuote


Subject
Written By
Posted
September 23, 2014 10:19AM
September 25, 2014 04:13PM
September 26, 2014 01:15PM
Re: storing username
September 27, 2014 12:50AM
September 29, 2014 11:51AM
September 29, 2014 12:06PM
September 29, 2014 12:11PM
September 29, 2014 12:13PM
September 29, 2014 03:21PM
September 29, 2014 12:36PM


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.