Mustafa Yalcin Acikyildiz wrote:
hello.
i have a speed problem ;).
table:
title_id bigint(50),title char(200), cdate datetime
query:
select title, max(cdate) as mdt, count(title_id) as num
from entry
where (date_format(cdate, '%Y-%m-%d %H:%i:%s')
The function in whre clause forces a full table
> table:
> title_id bigint(50),title char(200), cdate datetime
>
> query:
> select title, max(cdate) as mdt, count(title_id) as
> num
> from entry
> where (date_format(cdate, '%Y-%m-%d %H:%i:%s')
> between '2004-05-07 00:00:01' AND '2004-05-08
> 23:59:59')
> and
> (on = 'Y')
> group by title
> ord
> i have a speed problem ;).
>
> table:
> title_id bigint(50),title char(200), cdate datetime
Next time, please provide information about existing indices and provide
output of EXPLAIN of the query...
> query:
> select title, max(cdate) as mdt, count(title_id) as num
> from entry
> where (date_f
* [EMAIL PROTECTED]
> Description:
> I try to get the last 5 different times and the first 5
> different times. There is a difference of aproximately
> 1 minute and 40 seconds between this to queries. I do not see
> reason for the difference in the execution times.
There is a problem in some case
