在MySQL中,日期比较是要比like快很多的(尽管我的本本上数据很少,差别依然很明显):

但是在Access中的结果让我大吃一惊,日期比较比字符串模糊匹配还要慢:

还不知道sqlite如何,有待测试,如果好的话就把我的blog的数据库给换掉,嗯~

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.