Re: Speed Problem

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

Re: 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') > between '2004-05-07 00:00:01' AND '2004-05-08 > 23:59:59') > and > (on = 'Y') > group by title > ord

Re: Speed Problem

> 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 >

Speed Problem

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') between '2004-05-07 00:00:01' AND '2004-05-08 23:59:59&

Re: MySQL speed problem

Andre MATOS wrote: Hi, I faced a speed access problem today with the MySQL. In the morning was working well and fast, but after lunch when I tried to access the MySQl using Apache+PHP it was terrible. For just a select, it took 2 a 3 minutes to process. I checked the log files from Apache and P

MySQL speed problem

Hi, I faced a speed access problem today with the MySQL. In the morning was working well and fast, but after lunch when I tried to access the MySQl using Apache+PHP it was terrible. For just a select, it took 2 a 3 minutes to process. I checked the log files from Apache and PHP and I could not

Speed problem with INDEX

Hi all, i have an application writing bulk inserts periodically to a MyISAM table. This table has a multi-column index on two integer fields, in this way i can have an good query speed. Bulk insert are very speed, but when the table grows up to 20/25 MB, almost the inserts have a very slow spe

RE: Speed problem with sorted select statements

* [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

Speed problem with sorted select statements

NULL | 3418459 | where used; Using index; Using temporary; Using filesort | +---+---+-+--+-+ --+-+------+ 1 row in set (0.00 sec) Fix: Synopsis: Speed problem with sorted select statements Sub

Query Speed problem...

I just added a fulltext index to a table, and MATCH queries on the table are timing out. Can anyone offer any insight on this? The table has 2000 rows of data in it, and phpMyAdmin reports it as having a total size of 244,228 bytes. Table Structure: CREATE TABLE Customers ( ID mediumint(9) NOT