MySQL Forums
Forum List  »  Optimizer & Parser

datetime vs date,time
Posted by: Alberto González
Date: May 16, 2007 02:31AM


I have a table with ~1500000 records with two columns date,time.

I thought change two columns to one as datetime.

I created a tables and i saw the difference:

date,time it's 0,20 secs fastest than datetime with ~1500000

i used select benchmark(10000000,(select count(*) from tbl1 order by field desc));

1 row in set (6.93 sec)

and select benchmark(10000000,(select count(*) from tbl2 order by field2,field2 desc));
1 row in set (6.76 sec)

Options: ReplyQuote

Written By
datetime vs date,time
May 16, 2007 02:31AM
May 17, 2007 05:07AM
May 17, 2007 06:08AM
May 17, 2007 10:08AM

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.