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 ---------------------------(end of broadcast)--------------------------- TIP 7: don't forget to increase your free space map settings
