测试环境
mogodb
MongoRepository(spring框架里面的)
10000条记录
A
@Document(collection = "DateTests")
public class DateTestInfo extends BaseDomain {
/**
* 唯一id
*/
@Field("id")
@Setter
@Getter
@Indexed(name = "index_platform_id", unique = true)
private long id;
@Field("date")
@Setter
@Getter
private Date date = new Date();
}
B
@Document(collection = "DateTests")
public class DateTestInfo extends BaseDomain {
/**
* 唯一id
*/
@Field("id")
@Setter
@Getter
@Indexed(name = "index_platform_id", unique = true)
private long id;
@Field("date")
@Setter
@Getter
private int date = 1551260428;
}
C
@Document(collection = "DateTests")
public class DateTestInfo extends BaseDomain {
/**
* 唯一id
*/
@Field("id")
@Setter
@Getter
@Indexed(name = "index_platform_id", unique = true)
private long id;
@Field("date")
@Setter
@Getter
private long date = 1551260428738L;
}
相同环境下的数据
代码 | 存时间(单位毫秒) | 取时间(单位毫秒) |
A | 143 | 99 |
B | 139 | 101 |
C | 124 | 98 |
结果日期数据用Mongodb 用Date Int long 存取 基本没区别。考虑到查询显示方便 推荐 还是Date