Hi all,
> give us the result of these queries:
> SELECT COUNT(*) FROM articletbl;
268726 records, it takes 34169 ms. to compute this
> SELECT COUNT(*) AS c FROM articletbl WHERE
> mydate BETWEEN '2004-04-24' AND '2004-05-24';
18982 records, it takes 34249 ms. to compute this.
> SELECT COUNT(*) AS c FROM articletbl WHERE
> mydate = '2004-04-24';
850 records, it takes only 40 ms. to compute this.
It is evident that there is a problem here! Am I wrong??
Regards
Ismail Kizir