On Feb 11, 2004, at 1:47 AM, nyem wrote:

It works fine on small number of rows, but when the table reaches 400 rows the time it took to execute the query was 16 sec. And my cpu shot up to 100% whenever I populate 1000 rows. What have I done wrong here?

Did you try creating an index on the `date` field?


     ___/
    /
   __/
  /
 ____/
 Ed Leafe
 http://leafe.com/
 http://opentech.leafe.com


-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]



Reply via email to