MySQL Forums
Forum List  »  Optimizer & Parser

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

Hello:

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


Subject
Views
Written By
Posted
datetime vs date,time
9068
May 16, 2007 02:31AM
3527
May 17, 2007 05:07AM
3043
May 17, 2007 06:08AM
2937
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.